Excel Custom Graphs

Can you create a Graph using bars for some data and switch to using lines for
the rest using 2 axes.
i.e. Charting production numbers The bars and one axis for previous years
totals. The line would be for each week for present year using the other axis.

Make the chart with all lines or all columns (whichever type is
predominant). Select a series you need to change, go to Chart Type on
the Chart menu, and change this series to the other type. Repeat with
each additional series you need to change (you can select the next
series and press the F4 key to repeat the last operations).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

kgscrapman wrote:

> Can you create a Graph using bars for some data and switch to using lines for
> the rest using 2 axes.
> i.e. Charting production numbers The bars and one axis for previous years
> totals. The line would be for each week for present year using the other axis.