ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I want to draw a line through the columns of a chart, plot the o. (https://www.excelbanter.com/charts-charting-excel/21965-i-want-draw-line-through-columns-chart-plot-o.html)

Dewey

I want to draw a line through the columns of a chart, plot the o.
 
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.

Jon Peltier

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.



All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com