ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding a line to the line/column chart? (https://www.excelbanter.com/charts-charting-excel/130450-adding-line-line-column-chart.html)

Steven

Adding a line to the line/column chart?
 
Is there anyway I can add a second line to the line/column chart?
Basically I have 3 sets of data that I want to plot vs. time on the
same graph. 1 using the column format, the other 2 being lines
connected by data points.


John

Adding a line to the line/column chart?
 
Create the chart using all the data, right click on the one you want to
change to a line and select chart type from the dialogue box and choose the
type you want. There are a few restrictions on the mix you can have though.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Steven" wrote:

Is there anyway I can add a second line to the line/column chart?
Basically I have 3 sets of data that I want to plot vs. time on the
same graph. 1 using the column format, the other 2 being lines
connected by data points.



Steven

Adding a line to the line/column chart?
 
Thanks a lot John, really appreciate it.



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

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