Line - Bar Graph, 2 axis

[TSNS]

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

 

[Jon Peltier]

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