Double stack and double line graph

**Karen311261** · 10-06-2010, 04:56 AM

Hi All
I want to be able to create a graph that will have two bars per month entry and two lines
Attached is sample data
If anyone can point me in the right direction I would appreciate it
Many thanks
Karen

**Andy Pope** · 10-06-2010, 05:12 AM

It's not clear what exactly your chart should look like. And the data does not help as 2 series are zeros.

Should the bars be stacked? If so does it make sense to stack them?

**jppinto** · 10-06-2010, 05:31 AM

I agree with Andy, it's not clear what you want to do with this. Can you please explain in detail so that we can help you?

jppinto

**Karen311261** · 10-06-2010, 11:18 AM

Hi Guys
No I want the bars to be side by side
thanks

**Andy Pope** · 10-06-2010, 11:23 AM

Still not really a lot of info, but still.

Create a cluster column on all 4 columns of data.
select the a series you want as line and change the chart type to line.
repeat for other series.

This will give you lines that are placed in the middle of the 2 colulmns.
If you want lines in the middle of each individual column you will need to plot xy-scatter rather than line chart and you will need to provide individual X values for each data point.