Help with charts please

[jedibrown]

Hi - I just wondered if anyone knew how I could create a chart (standard column) with an average line in Excel 2010?

Thanks

 

[VoG]

This should help you http://www.andypope.info/charts/averageline.htm

 

[jedibrown]

Thanks - I have looked at that before but couldn't work out how to format the second series as a line chart?

Thanks

 

[jedibrown]

Don't worry - it was me being thick! I have worked it out now.

Thanks for your help

 

[VoG]

OK, try Lines - Add Lines to a Chart here http://peltiertech.com/Excel/Charts/ChartIndex.html