Constant % on X axis

G

GM

Hi
I'm looking at displaying data on a line graph where the Y value will vary
and the X axis will always been set on a 0 to 100% scale.
I'm trying to display various sets of data on the same graph, however the
data sets are not all set over the same scale. For example 1 set may have 20
rows of data and another up to a 100 rows! (both comparing one variable Y
value against an X value between 0 - 100%).
Does anyone know how I can get the data to spread equally accross the x axis?

Appreciate any ideas!
 
D

David Biddulph

Rather than using line graph, use XY graph.
Calculate your X value in the data sheet, then plot XY from there.
 
G

GM

Thats excellent, thanks very much

David Biddulph said:
Rather than using line graph, use XY graph.
Calculate your X value in the data sheet, then plot XY from there.
--
David Biddulph




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Negative values on X axis 6
How can I make a scatter plot graph with a category x-axis? 0
Chart with differing x axis 1
Moving X-axis in Excel Graph 1
Formatting 'X' Axis -- 2 fundamental differences 7
X Axis to Scale 2
Scale on X & Y Axis of the scatter chart 3

Top