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
Use text descriptors as Y axis units 1
Chart with differing x axis 1
Negative values on X axis 6
Scatter chart with categories on x-Axis 2
Overlaying 2 Data Series with Different Time (X) Axis 3
X Axis to Scale 2
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1

Top