How to create health columns individually in a dash board ? using donut chart or Pie chart?

here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    I am not sure if this is where you are stuck, but to create a pie chart....

    Create a Dashboard using the button at the top right


    Add Chart


    Add Data


    Select your sheet from the tree on the left

    Highlight the data for the chart

    Click OK

    Change Type to Pie

    Change series colors

    Change the Title

    You have a chart


    Repeat for other charts. Or copy the first one and edit the data source. (It doesn't make a lot of difference which way you do it as you will still need to change the type, and probably the colors, every time)

    Is that what you are looking for?

    If not, can you explain what you want your dashboard to show?

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    I am not sure if this is where you are stuck, but to create a pie chart....

    Create a Dashboard using the button at the top right


    Add Chart


    Add Data


    Select your sheet from the tree on the left

    Highlight the data for the chart

    Click OK

    Change Type to Pie

    Change series colors

    Change the Title

    You have a chart


    Repeat for other charts. Or copy the first one and edit the data source. (It doesn't make a lot of difference which way you do it as you will still need to change the type, and probably the colors, every time)

    Is that what you are looking for?

    If not, can you explain what you want your dashboard to show?

  • Wahh!! Thank you. this is what i am looking for.. :)

  • KPH
    KPH ✭✭✭✭✭✭

    Great! Glad I could help.