charting in 2003

[Sara Tanner]

My client wants a line chart on 2 axes. The problem I am having is 1 line
they want plotted by years, the other quarters. the yearly line does not
show up, I had to put no values in between where the quarters are leaving 4
blank spots. Is it possible to plot ?

 

[Glen (TD DTP)]

Sara,
It is definately possible in Excel, but I have not have a chance to test in
the Powerpoint charting function.
What you need to do is add a Second X Axis, to do this put your second set
of data on a second y axis first. You should then be able to select a 2nd X
axis. This way you can plot two different series types (categories -
quartres, and time series) on one chart.
Hint - once you have the two additional axis scales set, you can hide them
by selecting none on all format options (line, markers etc etc).
Like I said, this works in Excel, please try in PPT charting and tell me if
it work there too.

 

[Glen Millar]

Glen,

Vegemite AND a koala to keep you warm!

--

Regards,
Glen Millar
Microsoft PPT MVP

Please tell us your PowerPoint version

Tutorials and PowerPoint animations at
the original www.pptworkbench.com
glen at pptworkbench dot com

 

[Glen (TD DTP)]

Hey Glen,
was driving to Montreal last weekend and noticed a "Glen Miller Road"
heading towards Grafton - Didn't realise you had property up this way.
At -30 degrees last weekend the Koloa would be helpful addition.