Excel chart wont do wot i need

  • Thread starter Thread starter ExcelUser123
  • Start date Start date
E

ExcelUser123

I would like to create several seperate line graphs some values maybe 8
to 90 and others 70 to 80. My problem is i would like all the top line
of the charts to be 100 so that they can be compared easly. But exce
keeps changing them all, some times they are 100 and others are 88 an
so on. Cant put all in the same graph because there are to many. I
there any way of doing this.

Thank Rich..
 
You can create yr chart, right-click the axis u want to reformat and choose
Format Axis/Scale. Set the scale as appropriate, and uncheck the Auto
checkboxes before the values.
GL,
Henk
 
Back
Top