|
Modifing data to show up better in chart.
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 |
How do I use the article number you referenced in your reply.
"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 |
What article number?
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How do I use the article number you referenced in your reply. "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 |
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 |
In article ,
says... 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 |
| All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com