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]

In article <[email protected]>,
[email protected] 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

[Dan]

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

"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] 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
>

[Tushar Mehta]

What article number?

--
Regards,

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

In article <[email protected]>,
[email protected] says...
> How do I use the article number you referenced in your reply.
>
> "Tushar Mehta" wrote:
>
> > In article <[email protected]>,
> > [email protected] 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
> >
>

[Mike Punko]

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

"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] 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
>

[Tushar Mehta]

In article <[email protected]>,
[email protected] 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