I am having trouble scaling the x-axis so that the intervals are equal. The
source data is not in equal intervals, it goes
0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
interval on the graph 0.2? I'm using XP.
I am having trouble scaling the x-axis so that the intervals are equal. The
source data is not in equal intervals, it goes
0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
interval on the graph 0.2? I'm using XP.
Don't make a line chart. Make an XY chart, using the markers and lines
option. Then you can double click the X axis and set any appropriate
tick spacing.
An XY chart treats X and Y as continuously varying numerical values. A
line chart treats Y that way, but treats X as non-numerical text labels.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
broncogirl wrote:
> I am having trouble scaling the x-axis so that the intervals are equal. The
> source data is not in equal intervals, it goes
> 0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
> interval on the graph 0.2? I'm using XP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks