1 Bar and 2 lines? Or a better solution offered?

**Phil the Bear** · 03-12-2009, 07:15 AM

I have an issue where a chart we have been producing for a number of months keeps getting altered by our Director - but he wants to maintain the same format.

Initially it reported the number of Daily Print Runs and how many errored.

It later evolved to be the number of Daily Print Runs, but errors were only reported if they were not resolved by 12.30pm.

Now it needs to be Daily Print Runs, the number of these that errored AND the number of those that were not resolved by 12.30pm.

I have tried any number of ways to have the number of Daily Print Runs represented by a column. And then the number of errors and those not resolved by 12.30pm BOTH as lines.

But I do not seem to be able to do this.

Can someone explain this to me? Or offer a better solution if there is one?

One caveat is that the chart needs to contain the 8 months of data in it. I am not allowed to reduce this data or cut it into 2 charts.

**Andy Pope** · 03-12-2009, 07:41 AM

I'm guessing you created the chart using the Built-in Line/Column combination.

Simplest thing to do is right click chart and pick Source Data.
On Data range tab change the reference to ='Chart Data'!$B$1:$E$167

This will cause the Error Runs to change to column. Select this series and change chart type to line.

Select the new Error runs series and set it back to the primary axis.