ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a combination graph with stackedColumns+lineGraph (https://www.excelbanter.com/charts-charting-excel/30488-how-do-i-create-combination-graph-stackedcolumns-linegraph.html)

ChartQuestion

How do I create a combination graph with stackedColumns+lineGraph
 
I'm trying to create a custom graph which has both stacked columns bar graph
and also a line graph. I know excel has a combination graph with a bar graph
and a line graph, but there is no option for a stacked bar and a line

Any ideas?



bj

plot the data you want to be a line as part of the stacked column chart
Select the data set on the chart
got to <chart<Chart type and select <line and select the details
You wil now have a stacked cart with a line.

"ChartQuestion" wrote:

I'm trying to create a custom graph which has both stacked columns bar graph
and also a line graph. I know excel has a combination graph with a bar graph
and a line graph, but there is no option for a stacked bar and a line

Any ideas?




All times are GMT +1. The time now is 03:00 AM.

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