## 25 Q & A posts tagged with graph

### Thinner bars than default settings in excel?

I have selected the thinnest bar available in Excel. Are there ways to download a custom width that is slightly thinner that would be noticeable on a print out? I have to do some graphing and the thinnest bars are still slightly too thick.. I dont want to use dashed lines either

### Answer

As far as I understood you

You can modify the width of these bars by going Right click then selecting Format

These options can do that for you

If not, then try to change the type into 3D, then you can modify gaps too

good luck

### Please Help! How would i draw this graph on excel 2010?

http://imgur.com/IMLLE

Sorry the pic isn't rotated, and it's kinda small...

I can't figure out how to graph it:S I don't know how to insert negative x values in the graph, and i don't know how to change the default x values of 1,2,3,4, etc. to different numbers...

Please help! best answer will get 10 points today cause i'm in a ruuuush!

Thanks!

### Answer

This one looks like a SIN(x) graph for me

just do 1, 2, 3, 4, etc in col A, then do

=Sin(A1)

in column B

Then graph it

hope this is not too late

### How do you graph data on Excel using two Y axes?

I have the values for the data on the left side of the graph but I want them on the right side. When I right the axis there isn't any 'properties' but Format Axis instead. I'm using Excel 2010 by the way.. Any idea on how to get the Y axis to the right side?

### Answer

You need to do like this

http://folder8.com/View/?W0V

### How to make a double line graph on Excel?

I have the temperature of the days of the week high and low how do I put that into a double bar graph?

### Answer

I have a file that does that, have it here

http://Folder8.com/F/?Yan

file called "High_Low_Temperature Chart.xls"

let me know if that helped

### How do you change the what order lines go on a graph in excel?

I have an excel graph and i want to move one line in front of the other. How do I do that?

### Answer

In Excel 2007

- Select the chart

- Go to Design tab > Select Data > then select the series you want to move and click on the up and down arrow in that window to move it up or down

In Excel2003

- Select the Chart

- Go to Chart > Source Data

- In Series tab, move it up and down as required

If you are talking about the 3D chart you have, then that can be made the same way since Excel is using that order to draw the lines

VBAXLMan

### How can I insert intervals of numbers, not discreet elements into Excel?

I need to sketch the sin, cos functions' graph in Excel. I have a problem with a domain. I don't want to manually type myriad values - even then, the graph is sharp, not curved, and inaccurate. Is there a possibility that I simply set an interval, infinite, but bounded set, as a domain? If yes, how do you do it?

### Answer

You need as many points as you can to do the exact curved sin

to answer your question, do the following:

- Do the first number you want in a cell, say you do 5 in cell E4

- Now do the second number with the intervals into the second say.

So if you want to have the numbers as 5, 15, 25 (with 10 interval), put 15 in cell E5

- Now select both cells

- Drag the selection from the black square at the right bottom corner down to whatever range you want.

Or, you can also do:

- Put 5 in cell E4

- Select some range of cells including cell E4 (Cells E4 to E20)

- Go to:

Edit > Series > Fill (if you have Excel2003 or earlier)

Home > Fill > Series (below SUM sign)

And select the interval and stop value

VBAXLMan

### How do you label extra information on Excel line graphs?

So if I already made a line graph and then the instructions say that I need to label the point at which certain things happened in time along the line, how do I do that on Excel. (without doing it by hand)

Thanks :)

### Answer

What do you mean, "by hand" ?

You can do the following:

Show labels for all data points

Select the point you want to label

Click on it again (not double click), just click on it again after few seconds

Now you can modify that point's label

VBAXLMan

### How would I create the type of graph shown in the link below?

I have data in excel for the daily minimum and maximum temperatures and daily rainfall for a full year.

Also, what is the name of this style of graph?

### Answer

Use the regular column chart

It is called Histogram, but Excel will not recognize that name, use Column chart

Assuming you have the data listed by date.

VBAXLMan

### How do you put two different lines on a graph in excel?

Thanks.

I need a baseline and intervention line.

### Answer

In Excel, to control a graph, you need to design its table

So it is all about tables here

New line means new series, so you need to add another series to do that

I used to add another series, having same value for all data points, and add it to the graph series

VBAXLMan

### How to determine an unknown X value on excel?

So we had to do a beer's law plot in my chemistry class. I have an unknown sample's absorbance and I need to determine the concentration. We are suppose to use excel to do so. The absorbance is my Y value and the concentration is graphed on the X axis. How can I determine the concentration of my sample. Thanks for helping me!

### Answer

You should have either a formula that runs the graph

Or a graph so we can get the formula

You cannot do it other way

If you have a formula, you can easily apply to get X value using it

If you have a graph, then you need to add trendline (Right click on that curve and select "Add Trendline")

Doing so will show you a window that enables you to show the formula

from that formula you can get the X value

Let me know if you did or not, I can guide you through that process if you lost

VBAXLMan

### How do I make a half life graph on excel?

Excel keeps making it into a weird kind of graph, and I want a line graph with the years as the X axis and % left as the Y axis

### Answer

Once you have the values in two columns

Insert chart, make sure you select the XY-Scatter from the chart type

VBAXLMan

### How do i add 2 different sets of data to one graph on Excel 2007?

im doing a chemistry lab and i have to make a computer generated graph with excel. im using Microsoft Excel 2007 and im having trouble. ive added my info and for some reason it wont let me put the 2 different sets of data on the same graph. my two axis' are supposed to be temperature on the Y-axis and time on the X-axis. ALSO: if it is possible for you guys to help me find out how to do the "best fit line technique" i would really appreciate it.

### Answer

To add new series

- Select your chart

- Go to Design tab

- Click on "Select Data"

- Click "Add"

- Select the new series values/title, etc

That is all

Now regarding "Best fit line"

- Right click on the series you want to add best line to it (The line you want to get its best fit)

- Select "Add Trendline"

Hope this is what you are asking about

VBAXLMan

### How do you develop a Trend Equation graph on Microsoft Excel 2007?

I need to develop a trend equation graph for current ratios and other financial ratios, any help would be grateful, thanks

### Answer

What do you mean by "Develop"?

Need more info please

VBAXLMan

### How do you develop a Trend Equation graph on Microsoft Excel 2007?

I need to develop a trend equation graph for current ratios and other financial ratios, any help would be grateful, thanks

### Answer

What do you mean by "Develop"?

Need more info please

VBAXLMan

### Ms excel help.. .. finding the coefficient of correlation, r^2?

ok so i need help finding the r^2 of linear and nonlinear regressions, to compare which ones fit better......... using excel.

eg. if power reg. curve is 0.998 and quad. curve is 0.992 ... then id choose power reg,

i know how to do it on a graphing calculator... but i need it for an assignment......

so how do i find it for a curve?

p.s. ive got excel 2003.....

### Answer

Once you got a graph

- Right click on the line

- Select "Add Trendline"

- Select the type of that trendline

- Go to "Options" tab

- Click on "Show R2 equation"

That is all

VBAXLMan

### HELP?!?!??! Microsoft excel?

I made a bar graph on Microsoft excel but how do i label the bars (along the X axis) ??

plz help, rlly confusin

thnkx in advance =]

### Answer

In Excel2003, do these steps:

1- Select the graph

2- Go to Chart > Chart Options

3- Then go to Chart Titles and change the boxes for x-axis and y-axis labels

In Excle2007, do these

1- Select the graph

2- Two new tabs will be shown after the last one, go to

Layout > Axis title

Then do the Horizontal or Vertical one, based on your needs

VBAXLMan

### Auto Generate Calendar in Excel?

Anyone know how to generate a calendar, in excel, with appointment entries from worksheet data as a sourc?. Just like creating a graph and using worksheet as data source. Want to do the same thing, but populate a calendar. Thanks

### Answer

Here is a free calendar for any month any year

It also has the ability to show your appointments for a full year

http://www.file1.net/project.asp?id=k7frâ€¦

Enjoy it

VBAXLMan

### How to print a chart in Excel 2007?

Help! I have an assignment due tomorrow where I had to make bar graphs in Excel 2007. The graphs are showing up perfectly in print preview, but the actual bars won't print. The X and Y axis and chart title prints only. I have a HP Officejet 6210. I have no idea what to do. Thanks!

### Answer

You need to do these steps as they are the most popular reasons for problems like this

1- Clear history and cookies

2- Delete temporary internet files

Both 1 and 2 are in Internet options from Control panel

3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems

4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be

3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems

VBAXLMan

### Excel 2007 - Using words in the y-axis?

Hi, I'm trying to make a line chart and coordinating times with letter values where the time is on the X-axis.

i.e.

1200 is ACA

1300 is ACC

1400 is BAD

I need to put the letters/initials into the Y-Axis so instead of charting numbers to numbers, it'll do letters and on the Y-Axis I'll have AAA, AAB, AAC et cetera.

How do I do that? Thank you!

### Answer

The Y-axis is where the values are drawn, meaning you can not put letters since letters can not be drawn as line

The Y-Axis has the values that representing the line itself

Does that make sense?

VBAXLMan

### How do I draw a normal curve graph on Excel?

For my first set of data, I have a mean of 5.409090909 and a standard deviation of 1.370437585. For the second set, the mean is 4.590909091 and the standard deviation is 1.969289002. How can I draw a normal distribution curve? I have 22 values for each set. Any help would be appreciated.

Regards

### Answer

If I understood your question, do this:

Add new series (one for each mean and STDEV) with the same value for all points

And graph it

If this is not what you wanted, let me know

VBAXLMan

### How do I make a bar graph using Microsoft Excel 2003?

### Answer

Type in your data into cells as columns

Then go to

Insert > Chart

Select Bar from the chart type and click finish

This is the fast solution

VBAXLMan

### Getting an equation from points on excel 2007 ?!?

Alright I have a set of data points that I can graph but I don't know how to label the axis or to get it to derive an equation from a line. When I try to type in my AXIS label its says that the formula I tried has an error all I'm trying to do is label AXIS not put in a formula? what do I do?

### Answer

When you click on the chart Excel2007 will show you new 3 tabs at the top right

Go to "Layout"

Then click "Axis Titles"

And do your titles here

VBAXLMan is back

### I need excel spreadsheet help for my new company?

I'm starting a company based on commission only. I need an equation for excel in which I can input a $$ amount sold and have it auto read the different pay scales and generate their income. in $$s and on a line graph. The pay scale is as follows:

$612 to $1223 is 6%

$1224 to $2447 is 12%

$2448 to $4895 is 24%

$4895 to $ 8499 is 26%

and $8500+ is 27.5%

Thanks!

### Answer

Do this pay scale in a separate sheet, make it Sheet1 cells A2:C6 having A2 is 612, B2 1223, C2 6%

and so on

Now, in another sheet, put your amount in cell D4, and in E4 paste this:

=INDEX( Sheet1!C2:C6,MATCH( D4,Sheet1!A2:A6,1))

and this in F4

=D4*E4

That is all

VBAXLMan is back to feed your Excel needs

### Hey! is there any Excel expert who can solve this.....? are u here Mr VBAXLMAN..?.?

i would like to create a line chart in ms excel....where "runs" will be ploted in y axis, or vertical axis and "overs" in horizontal axis....

runs will ploted in 50 runs interval and overs will be in 10 overs interval....u might have seen this in cricket...

wait .....it's not so easy one....i've a few conditions

1) the resultant line will be displayed in a single line,,,,i repeat ..in a single line....as u would have noticed in cricket score analysis.

2)it will start from the (0,0) point...that means 0 run at 0 over...

and will travel with the increasing runs and respected overs...(as it is made in graph papers.)

3)i'm using msexcel 2002....so pls solve it in 2002 or older....

i think i've expressed it enough....

if u 've done it then try this for two teams for there score analysis .....obviously there will two seperate line for two teams , say India & Pakistan or Australia & NewZealand...

every good answer will get a thumbs up and the best answer ......u know better

### Answer

I got your e-mail.

The solution is all in the table that you will create for it

Wherever hard you think the chart is, the solution is in the table

Excel charts are created from tables, means that you can not (Never) create a chart without its data.

So we are (You and me) have to see how to build the table that will represent the chart

I can't e-mail you through Yahoo, you have not confirmed your e-mail there...

send me your e-mail address, I can not e-mail you

Enjoy my profile, I am the VBAXLMan

### How do I fix video playback on my computer?

Any time I play video on my computer the image gradually becomes green, regardless of the program I use.

### Answer

It seams to me that your SVGA card (Graphic card) problem. Try to reinstall the driver for it, If it still the same I am afraid that your Graphic card is damaged and need to be replaced.