Modifing data to show up better in chart.

[Mike Punko]

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

 

[Tushar Mehta]

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

 

[Dan]

How do I use the article number you referenced in your reply.

 

[Tushar Mehta]

What article number?

--
Regards,

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

 

[Mike Punko]

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

 

[Tushar Mehta]

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

You are welcome and don't be too hard on yourself. All of us have such
days. {grin}

--
Regards,

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