Modifing data to show up better in chart.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
 
Thanks Tushar right after I read your reply I gentle....but agresivly hit my
head agianst the wall. lol
 
Thanks Tushar right after I read your reply I gentle....but agresivly hit my
head agianst the wall. lol
Click to expand...
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
 
Back
Top