One diagram with different numbers of X-axes

[mrmean]

Hi I would like to create a diagram that should be able to change its content from a dropdown list. The dropdown should contain Days, Weeks, Month, and Quarters. My problem is that the number of entities on the X-axel is different from what I select in the drop dropdown list. Days have 31 different values on the X-axel, weeks have 13 values, Months have 12 values while quarters has only 4 values.

I would like to make the graph understand that if I select days from the dropdown list it should make room for all 31 different values, if I however select quarters the graph should adapt so that the piles are wider and there is only room for 4 piles and so on.

At the moment I have defined the graph to always look at row 2-32 regardless of what the dropdown states and hence the graph only looks good when I select days.

I may not use pivot tables to solve the problem

Anyone who know the solution for this or could give me a hint on how to continue?

Br
Martin

 

[Steve=True]

Here is a simple solution.

Involves making 4 separate charts the way you like them, and then when you choose which one to show with your drop down box, it uses the picture tool to show the correct one.

http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/

Steve=True