Chart Help!

trone1988

New Member
Joined
Aug 29, 2022
Messages
9
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hi Everyone

on my chart as you can see i want it broken up into Week 1,Week 2 Week 3, Week 4, Week 5 but with the offices under each week but i want the legend to be able to be changed on just the offices not the week.

so instead of the legend saying week 1 A this colour i want it to be like A,B,C,D,E and im able to change the colour based on each one but it not take into account the week for the legend

1662721487602.png
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Hello @trone1988

The legend is redundant in this case, since you have the label on the axis, so why bother?
 
Upvote 0

Forum statistics

Threads
1,215,081
Messages
6,123,016
Members
449,093
Latest member
ikke

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