ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create chart with columns and 2 lines? (https://www.excelbanter.com/charts-charting-excel/63328-how-create-chart-columns-2-lines.html)

Robert

How to create chart with columns and 2 lines?
 
Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?

Andy Pope

How to create chart with columns and 2 lines?
 
Hi,

Just create a standard line chart and the select the series you want to
plot as columns. Right click and choose Chart Types. Select the required
line chart.

Cheers
Andy

Robert wrote:
Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 08:34 PM.

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