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

Thank Rich...


--
ExcelUser123
------------------------------------------------------------------------
ExcelUser123's Profile: http://www.excelforum.com/member.php...o&userid=34448
View this thread: http://www.excelforum.com/showthread...hreadid=542075

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

"ExcelUser123" wrote:


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

Thank Rich...


--
ExcelUser123
------------------------------------------------------------------------
ExcelUser123's Profile: http://www.excelforum.com/member.php...o&userid=34448
View this thread: http://www.excelforum.com/showthread...hreadid=542075

Wow.... :) Works a treat....

Thanks for your help...

Rich


--
ExcelUser123
------------------------------------------------------------------------
ExcelUser123's Profile: http://www.excelforum.com/member.php...o&userid=34448
View this thread: http://www.excelforum.com/showthread...hreadid=542075