| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I draw a line of best fit? | Charts and Charting in Excel | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
| When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
| how do I draw a line in a chart at a specific location | Charts and Charting in Excel | |||
| Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions | |||
Linear Mode
