Thanks Tushar right after I read your reply I gentle....but agresivly hit my
head agianst the wall. lol

"Tushar Mehta" wrote:

In article ,
says...
My Y1 axis is from 0-250 my Y2 axis is from 0-9000
When graphing percentages the line shows up at the very bottom since 99% < 1
is there a way I can multiply these percentages by 100 to show them as 9900%
= 99

Normally you would just make then a 2nd axis but as you can see I already
have a second axis of 0-9000

In some empty column add a formula =100*{original data} and plot this
new column. Though, I suspect you will have to use a multiplier
significantly larger than 100 if that series is on the Y2 axis. ;-)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions