ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you create combination charts (line-coulmn) in excel 2007? (https://www.excelbanter.com/charts-charting-excel/158504-how-do-you-create-combination-charts-line-coulmn-excel-2007-a.html)

Leesah

How do you create combination charts (line-coulmn) in excel 2007?
 
I need to create a combination chart (Pareto line-column) in excel 2007 but I
can't find the combination chart wizard like the one in 2003. How do I go
about creating a line-column chart in 2007.

Andy Pope

How do you create combination charts (line-coulmn) in excel 2007?
 
Hi,

In 2007 you need to build your own combinations.
Start with a column chart based on all the data. Then select the column
series you wish to plot as line. You can now change the chart type.
Chart Tools Design Type Change chart type.

Cheers
Andy

Leesah wrote:
I need to create a combination chart (Pareto line-column) in excel 2007 but I
can't find the combination chart wizard like the one in 2003. How do I go
about creating a line-column chart in 2007.



All times are GMT +1. The time now is 03:24 PM.

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