X-scale adjustment

[JayJay49]

I like to adjust my X-scale in 10%, 20%, 30% ........100%. The total number of data-lines is 175, but I'd like tyo see the relative number share for my Pareto-analysis. For the Y-scale there is a logic screen to fill in the minimum, maximum etc, but this option seems to be missing for the X-scale?
There must be a simple solution to tackle this 'simple' problem?

Hope to hear from anyone soon.

Best regards

Jaap / Sassenheim / Holland

 

[KenMillard]

Are you referring to a chart?

Are you using an X-Y chart? If not, that may be just what you're looking for.

 

[Oaktree]

Have a look at Jon Peltier's writeup here:

http://www.peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

 

[RalphA]

One solution would be to insert a new column just after your current x-axis data. Assuming that data is in A3:A177, in new column B, cell B3, enter:
=A1/MAX(A$3:A$177)%
and copy down.
Now, do your plot, starting with column B. Done!