Data Viz Question

G

grumpus

New Member
Joined
Apr 9, 2004
Messages
4
I'm trying to automate this so that I can dynamically select an advertising campaign and based on that, this data would populate (the check marks). I thought a pivot table would do the job but I cant figure out the logic to make it happen. I thought and attempted an XY Chart but couldn't get it to work. Any suggestions/ideas would be greatly appreciated. Many thanks in advance...
Mike
 

Attachments

  • Screenshot 2023-03-14 140309.jpg
    Screenshot 2023-03-14 140309.jpg
    120.8 KB · Views: 5

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
Can you post the data from the data source using the xl2bb add in? The forum members would have recreate your data in order to help you without.
Help the forum help you? The link is below.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Data Validation Source for dropdown cell based on variable range?
Replies
2
Views
84
EssKayKay
E
L
  • Question
Filter date range to last 365 days (Pivot Table)
Replies
2
Views
430
LeonardH
L
S
  • Question
Multiple Use Radio or Checkmark Buttons
Replies
2
Views
118
ScottTemple
S
C
  • Solved
Index Matching + Data ranges inside a MINIFS()
Replies
3
Views
757
Alex Blakenburg
A
O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
442
KRice
K

Forum statistics

Threads
1,215,028
Messages
6,122,749
Members
449,094
Latest member
dsharae57

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