Want to create a similar view (as in the image) for Sales - Weekly & Monthly. If i select "Weekly" , the dimension gets changed to "Mon,Tue,Wed....." and if i select Monthly it gets changed to " Jan,Feb,Mar .....".
I don't want to create two charts and then overlap them.
If you use a button, you have to use a Macro to redefine the dimension on the fly.
You can also use a container object to get the tab effect, but in this case, you need to create two charts - one each with a different dimension, place these two charts in the container. You can change the caption of the individual charts to suit your requirement. But I understand you do not want to create two charts.