|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 14th, 2009, 07:38 PM
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
February 14th, 2009, 07:49 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
