Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the unit value on the x-axis?
My x values are 18.75, 37.5, 75, 150, 300. I need the axis to be linear from
0 to 300, but Excel evenly spces my values creating an exponential graph out of linear data. How can I set the units to remain equal throughout the range 0-300? This is my work computer, and they just up-graded and the excel program that I was accustomed to changed, but I assume this is Excel 2007? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the unit value on the x-axis?
Perhaps you have chosen the wrong Chart Type? If you have used the
misleadingly named "Line Chart" it will treat the X-values as categories, not as number values. You need the equally confusingly named XY-scatter. -- David Biddulph Terry wrote: My x values are 18.75, 37.5, 75, 150, 300. I need the axis to be linear from 0 to 300, but Excel evenly spces my values creating an exponential graph out of linear data. How can I set the units to remain equal throughout the range 0-300? This is my work computer, and they just up-graded and the excel program that I was accustomed to changed, but I assume this is Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unit Compatibility | Excel Discussion (Misc queries) | |||
Unit Forcast | Excel Worksheet Functions | |||
Time scale X axis with Major Unit of month | Charts and Charting in Excel | |||
Different unit distance on axis | Charts and Charting in Excel | |||
CF for over/under mean unit | Excel Worksheet Functions |