Clustered Cylinder Graph

**steph67** · 12-19-2010, 12:31 PM

Originally Posted by Richard Buttrey

Hi,

I don't believe you can mix 3D (cylinder) and 2D (line) series on the same chart. Can you not use bars instead of cylinders, in which case you can combine the two?

Rgds

I more than happy to comprimise on artistic look for quality of data

**Richard Buttrey** · 12-19-2010, 12:46 PM

Hi,

In that case just right click on the chart, select Source data and add the new series for average. i.e. this will be the =AVERAGE($B$1:$B$7) function copied to C1:C7.

Then right click the new series (default) column, pick Chart Type and select 'line'.

Rgds

**steph67** · 12-19-2010, 01:02 PM

Originally Posted by Richard Buttrey

Hi,

In that case just right click on the chart, select Source data and add the new series for average. i.e. this will be the =AVERAGE($B$1:$B$7) function copied to C1:C7.

Then right click the new series (default) column, pick Chart Type and select 'line'.

Rgds

Thats great - thanks