• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Dashboard

Hi Team

I am preparing a dashboard where I need chart to be dynamically which is completly based on a table above in the file. I am uploading the file please help and I am not able to make charts dynamic.

Thanks and Regards
Ratan Bhushan
 

Attachments

  • OCR-PSTN.xlsx
    229.3 KB · Views: 24
Hi Ratan,
Please see enclosed your file.

I have used Form Control ComboBox to make the chart dynamic in place of your data validation.
Also, have a look at Sheet "Multiple Q" which i have inserted additionally. In this you can choose any combination of Q to plot on graph (which is not possible in your sheet where only one Q is plotted on graph). You can certainly change the graph type or other details as per your requirement. If you do not have any use for it you can simply delete the Sheet "Multiple Q".

Thanks.
 

Attachments

  • OCR-PSTN.xlsx
    241.7 KB · Views: 30
Hi Ratan,
Please see enclosed your file.

I have used Form Control ComboBox to make the chart dynamic in place of your data validation.
Also, have a look at Sheet "Multiple Q" which i have inserted additionally. In this you can choose any combination of Q to plot on graph (which is not possible in your sheet where only one Q is plotted on graph). You can certainly change the graph type or other details as per your requirement. If you do not have any use for it you can simply delete the Sheet "Multiple Q".

Thanks.

I have made some changes to the chart which I have been preparing...
Please check as I am uploading the file.
But,in that chart, I am unable to get the base line from the axis line, it is starting from the bar. I need to make it right. Please check and advise the same.
 
I have made some changes to the chart which I have been preparing...
Please check as I am uploading the file.
But,in that chart, I am unable to get the base line from the axis line, it is starting from the bar. I need to make it right. Please check and advise the same.
 

Attachments

  • OCR-PSTN(1).xlsx
    234 KB · Views: 31
  • OCR-PSTN(1).xlsx
    234 KB · Views: 25
Back
Top