I am having a difficult time creating a stacked chart.
I have attached the spreadsheet and highlighted what I need vs. what I have.
Actually googled it and followed directions, but I cannot figure out what I am missing.
Stacked chart assistance
-
- 4StarLounger
- Posts: 579
- Joined: 10 Feb 2010, 17:32
Stacked chart assistance
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Stacked chart assistance
Click anywhere in the chart.
On the Chart Design tab of the ribbon, click Select Data.
Under 'Horizontal (Category) Axis Labels', click Edit.
Clear the box, point to the cell with 2023 (B1), then click OK.
Select the first series under 'Legend Entries (Series)', then click the down arrow button 'v'.
Click OK.
O'd leave the minimum of the x-axis at 0.
On the Chart Design tab of the ribbon, click Select Data.
Under 'Horizontal (Category) Axis Labels', click Edit.
Clear the box, point to the cell with 2023 (B1), then click OK.
Select the first series under 'Legend Entries (Series)', then click the down arrow button 'v'.
Click OK.
O'd leave the minimum of the x-axis at 0.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 579
- Joined: 10 Feb 2010, 17:32
Re: Stacked chart assistance
Thank you HansV so much. Works perfectly.
-
- 4StarLounger
- Posts: 579
- Joined: 10 Feb 2010, 17:32
Re: Stacked chart assistance
I do apologize. Once again, I was not clear.
I need the HP Edits to be part of the Total transactions.
So the blue would be 9,475,702 and the HP Edits would be "part of" the Total transactions. Not "in addition to" the Total Transactions.
I am very sorry for missing that.
Michael
I need the HP Edits to be part of the Total transactions.
So the blue would be 9,475,702 and the HP Edits would be "part of" the Total transactions. Not "in addition to" the Total Transactions.
I am very sorry for missing that.
Michael
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Stacked chart assistance
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 579
- Joined: 10 Feb 2010, 17:32
Re: Stacked chart assistance
Thank you HansV