ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Constant % on X axis (https://www.excelbanter.com/charts-charting-excel/247043-constant-%25-x-axis.html)

GM

Constant % on X axis
 
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!

David Biddulph[_2_]

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

"GM" wrote in message
...
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!




GM

Constant % on X axis
 

Thats excellent, thanks very much

"David Biddulph" wrote:

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

"GM" wrote in message
...
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!



.



All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com