Switch to change column used for Legend in bubble chart

G

gazpage

Active Member
Joined
Apr 17, 2015
Messages
393
Hi,

I have a bubble chart showing a breakdown of sales and profit by product type. I'd like a drop down box that allows selection of either Product Type or Geography and then the breakdown changes to reflect the selection.

I'm familiar with disconnected slicers, but not sure that works for the legend in a chart as they only take columns (I think). Any suggestions?

Thanks
Gary
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

tazeo
  • Question Question
Need help with copying worksheets and creating pivot tables/charts in new workbooks using Macro
Replies
0
Views
701
tazeo
tazeo
R
  • Question Question
Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.
Replies
1
Views
1K
RajK2005
R
K
  • Question Question
help with a combobox and how it loads its list (its selections)
2
Replies
13
Views
1K
Anthony47
A
A
  • Solved
Using IF STATEMENTS, CONDITIONAL FORMATS and VALIDATE to track tasks. HOW? PT. 2
Replies
5
Views
680
fjns
F
M
  • Question Question
Changing sheet references without the use of Indirect
Replies
2
Views
2K
m505753
M

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

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