Chart trouble - data w/duplicates

Sounds like you need to use a pivot chart - have you tried this?

Originally Posted by devo

Hi. Board newbie here.

I have data that looks like this:


Period Client Salesman Sales Inv
-----------------------------------------
1 Amazon Bob 5 5
1 Costco Sue 8 3
1 Walmart Joe 15 4
2 Amazon Jon 5 2
2 Costco Sue 8 0
2 Walmart Mary 15 8

and so on...

So values repeat: Period, Client, throughout the data.

I want a chart where you have a drop-down list, you select a Client (Amazon), it shows you their data (Sales & Inv) for the last year.

I understand the mechanics of doing a drop-down list, using dynamic Names instead of direct cell references, etc.

I had to put the Periods and Clients on seperate worksheets without duplicates to get them into drop-down lists without having dupes.

But how can I base a chart on say just the Amazon data without filtering it or copying just the Amazon data to a separate worksheet first? All the examples I've seen don't have repeating data like this.

Hi,

another option is as per the attached, make any selection or combination of selections required.

hth
---