ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I add an extra line to a line-column chart? (https://www.excelbanter.com/charts-charting-excel/73407-how-do-i-add-extra-line-line-column-chart.html)

moose

How do I add an extra line to a line-column chart?
 
Excel 2003.
I have 3 sets of numbers.
2 sets I want plotted as lines. (These are upper and lower limits of monthly
performance)
The third set of numbers is represent an actual performance; I want this set
represented as columns.
Each set is plotted monthly. (i.e.: x-axis is months of the year.)


Bernard Liengme

How do I add an extra line to a line-column chart?
 
Make a Line chart
Right click on one line in chart, use Chart type, make Column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"moose" wrote in message
...
Excel 2003.
I have 3 sets of numbers.
2 sets I want plotted as lines. (These are upper and lower limits of
monthly
performance)
The third set of numbers is represent an actual performance; I want this
set
represented as columns.
Each set is plotted monthly. (i.e.: x-axis is months of the year.)





All times are GMT +1. The time now is 06:20 PM.

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