Excel chart wont do wot i need

[ExcelUser123]

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

[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

"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
>
>

[ExcelUser123]

Wow.... Works a treat....

Thanks for your help...

Rich