Line - Bar Graph, 2 axis
 

Hi everyone,

I am trying to see a graph with usage, collections and the stock levels for
each month.

is it possible to have the collections as a bar, then usage as a line, as
well as the collections ( on a separate axis) as a line.

using the Custom Type graph " line- bar" i can get the last series to appear
as a line, but end up with 2 series of data being plotted as a bar graph.

Any Ideas

Thanks

Line - Bar Graph, 2 axis
 

Don't use the built-in custom charts. You'll pull your hair out.

Make a chart using the most common type, in your case a line chart. Select
and change each individual series you need to change. For example, select
the series you want as a bar, and convert it to a bar (right click the
series, choose Chart Type, then pick the type you want). Then select the one
you want on the other axis, right click, choose Format... and select the
secondary axis on the Axis tab.

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


"TSNS" wrote in message
...
Hi everyone,

I am trying to see a graph with usage, collections and the stock levels
for
each month.

is it possible to have the collections as a bar, then usage as a line, as
well as the collections ( on a separate axis) as a line.

using the Custom Type graph " line- bar" i can get the last series to
appear
as a line, but end up with 2 series of data being plotted as a bar graph.

Any Ideas

Thanks