Creating a Stack/Clustered Bar Chart

M

mjohnston0209

Board Regular
Joined
Nov 6, 2017
Messages
55
I was asked to put together a bar chart that shows daily actual progress per activity and compare it it to the weekly plan. I am not sure how to do this without creating two labels and entering the plan as daily values. Any help would be greatly appreciated!
 

Attachments

  • Desired Output.PNG
    Desired Output.PNG
    10.2 KB · Views: 10
  • Chart Components.PNG
    Chart Components.PNG
    16.2 KB · Views: 10
  • Excel Postioning.PNG
    Excel Postioning.PNG
    44.9 KB · Views: 5

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You must log in or register to reply here.

Similar threads

D
  • Question Question
Stacked and clustered combo chart
Replies
1
Views
115
Sergius
S
A
  • Question Question
Grand total line as a secondary axis to a clustered column
Replies
2
Views
401
auroraissccc
A
K
  • Question Question
This is driving me NUTS!! I just want to plot a stacked bar next to a regular bar
Replies
1
Views
146
RoryA
RoryA
A
  • Question Question
Creating a Pie Chart of a segment of a stacked bar in a Grouped Bar Chart (the bar chart I made is attached)
Replies
0
Views
306
afrailer
A
J
  • Question Question
Stacked Clustered Column Chart
Replies
0
Views
262
johnnypp
J

Forum statistics

Threads
1,223,956
Messages
6,175,614
Members
452,661
Latest member
Nonhle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top