| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fan charts | Charts and Charting in Excel | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
