Excel chart wont do wot i need

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..
 
H

HEK

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
 

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

Chart series select. 3
Grid Line Extensions ? (Excel 2007) 0
Triangulation chart 7
Gap Chart 3
Dynamic Range for Area Chart with a line graph inside it too 7
Excel 2007 charts: want to avoid zero values 1
create chart line 2
Getting the graph style I want 4

Top