Dynamic Chart

Hello,

I have a spreadsheet that has 4 Charts, which each one is set up from the Tracker 1 worksheet.

What I am looking for is a Dynamic chart system that will:
If the Dynamic is chosen for 'Total', it will display a larger Graph on the sheet to view
If the dynamic is chosen for 'HS or HG or SG', it will do the same as if the Total was chosen.
But
If the Dynamic was set up with an option to choose 'ALL', the 4 Graphs shows as you can see in the attached sheet.

The Dynamic also need to be able to have a range, so that if you chose Oct, Nov Dec etc, it would show that month.
It should also have a weekly click, so you can show more than 4 weeks or less if needed.

i hope this makes sense and that you are able to help me.

Many thanks

Pugg

I was wondering if anyone could possibly help me in any shape or form for the query I have posted for the Dynamic set up.

I know this may be far too much to task but if you could support with anything, I think that would be a start on the path to making the Dynamic set up work.

I appreciate all who have checked the post.

Many thanks

Pugg

Perhaps the attached will be of use to you.

On the second sheet I've added some drop down lists at the top. The first for selecting either All or one of the categories.
The other two are for a start and end date to be selected.

I've turned the file into a macro enabled workbook as there's a little bit of VBA that hides the big chart if All is selected and shows it again if one of the other categories is selected.

There are a number of dynamic named ranges that make it all work (Ctrl+F3 will open the named range manager so you can see how those work).

These dynamic named ranges drive the details in columns Q & R and that in turn drives the big chart.
You can hide these columns away for the sake of neatness.

Hope it's of use. Let me know if you have any questions on it.

BSB

Oh wow,

I didn't think that was possible and I want to thank you for your time you have put in to have that set up.

I will add that to the file I have and see how it turns out and will update you shortly.

May I ask how you have seperated the single charts to show large then when clicking ALL, all 4 charts show up.

Many thanks

Pugg

Happy to help

There are 5 charts all together. The 4 single ones you originally had and a new larger one I created and lined up so it covers the other 4.
When you select All a worksheet change event fires and makes the big chart invisible so you then see the smaller 4.
When you change it to something other than All, the large chart becomes visible again and hides the smaller 4.

BSB

I have checked the spreadsheet all works great, apart from:

When you click on ALL, the 4 Graphs show up but when you change either the start or end date, it still shows up as:
19th Oct to 29th Nov.

Can the Dynamic for the ALL 4 Graphs, when the Start or End date is chosen, the 4 Graphs Auto change as what it shows on the Single Graphs when chosen?

The sheet is Fab but found that the 4 Graphs will not change when clicking on the Dropdowns

Many thanks

Pugg

Sure they can. Just needs a few more dynamic named ranges.

See attached.

BSB

Thank you very much,

Ill now add to the file and when I update all the data on Monday, ill test it out and see what shows up.

A quick test just now and wow fantastic, works perfect.

Many thanks for the quickness in returning the reply.

Many thanks

Pugg

No problem at all.

Shout if there are any issues after updating on Monday and we can revisit it then if necessary.

Have a good weekend.

BSB

The file I have is larger than what I have sent you, so I could not show you how it all works.
Im not sure how i can attach the file to show you so you can add the Dynamic to what i have asked for.
If there is a way to show you, please let me know.

Many thanks

Pugg

Now that I've shown you how it's done, it's over to you to translate that into your actual workbook.

I could do it all for you, but I'm not sure you'd like the number on the invoice I'd be sending you way after!!

Give it a go and post more questions if you get stuck. It's the best way to learn.

BSB

Your a star and thank you for the input that you have given me for this.

I will on Mon update and see how it pans out, if it works or not, one way or the other I will let you know but hoping the transfer will fit into the original file.

Once again, many thanks for your support and help.

Pugg

Hi,
I have been trying to load the data updated from the spreadsheet to my original sheet, so that the Dynamic Graphs work.
Unfortunately I'm coming stuck, where the 4 Graphs and Individual Graphs (when the tabs are chosen) do not pull from the dates selected.

As the spreadsheet I have is too large to download for you to view, I had to shorten when i sent out, asking if the Dynamic was possible, which you have completed.

is there anyway you can view the sheet I have and let me know where its going wrong or if I am going wrong with the entries etc.

Many thanks

Pugg