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
|
|||
|
|||
x-axis range
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. |
#2
|
|||
|
|||
x-axis range
Hi,
Use the XY Scatter rather than the Line chart. Cheers Andy GaijinSue wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
x-axis range
Make an XY chart not a Line chart
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "GaijinSue" wrote in message ... 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. |
#4
|
|||
|
|||
x-axis range
In addition to making an XY chart instead of a line chart (you can make
Excel connect the points), you can remove the column label above the X axis, but keep the label(s) above the Y value column(s). Excel will recognize that the values in the first column are different, and use them as category labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "GaijinSue" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manually Setting Date/Time Range of Axis | pittpanther | Charts and Charting | 1 | September 20th, 2005 03:54 AM |
Printing named range only | ray | Worksheet Functions | 4 | April 26th, 2004 05:29 PM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |