ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create a stacked chart (https://www.excelbanter.com/excel-discussion-misc-queries/190342-how-create-stacked-chart.html)

M.ROD[_2_]

How to create a stacked chart
 
I do not know how to create a staacked Chart.
I try to but the info comes out stacked into one whole column.
What are the general step or tricks?

ShaneDevenshire

How to create a stacked chart
 
Hi Rod,

You need to have your data set up something like this:

Axis Labels Series1 Series2
Name1 88 40
Name2 51 11
Name3 21 95
Name4 90 13

Select all the data and click the chart wizard, select the second option
under Column type and click Next, experiment with the Rows & Columns option
button to see which one you want, then Click Finish.
--
Cheers,
Shane Devenshire


"M.ROD" wrote:

I do not know how to create a staacked Chart.
I try to but the info comes out stacked into one whole column.
What are the general step or tricks?



All times are GMT +1. The time now is 12:35 AM.

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