View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Dewey -

Make your column chart with one extra series, which contains the overall
results. Select this overall series, choose Chart Type from the Chart
menu, and select a suitable Line style.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dewey wrote:

I have a basic column chart showing regional sales results by month. I would
like to draw a line through the columns. The line represents the overall
(all regions combined) sales results. The line needs to have a point for
each month that represents the sales number.