Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do I get the x-axis to be a range of "values" instead of "categories"?
I am trying to do a line chart with values over a % range, but I do not have values evenly spaced over the entire range (The chart is asymptotic and I only need to see values from 0 to 40 or so) e.g.: X Y 0.5% 28.8% 1% 44.8% 2% 62.2% 5% 80.9% 10% 89.9% 15% 93.4% 20% 95.3% 35% 97.7% I get the X axis evenly spaced in 8 categories. Seems like older versions of Excel (I am using Office XP/2002) allowed me to set the range and divisions within the range. How do I handle this now? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stock High-Low-Close Chart | Charts and Charting in Excel | |||
Data Validation range | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel |