Dashboard chart values too large

04/21/21
Accepted

I've created a dashboard for our campus to show how much of our Fall schedule will be taught in person vs online. The total of all the data is 100%, yet the stacked bar chart goes to 120%. Fortunately, the legend is light and hard to see, but still, we are a university, so I should be able to do an accurate chart. I'm pulling the data off of a report, though I originally entered it in a sheet where I verify that the numbers add up to 100%. I have two versions of the chart in dashboards, one for all campuses and one just for Pullman campus. Here are links to the published versions: https://registrar.schedule.wsu.edu/students/campus/ and https://registrar.wsu.edu/. The extra space looks funny and I'd like to remove it and put the dates the data is updated on the right, but need the chart larger first so have the update dates at the bottom. Any suggestions for improving the way this looks are appreciated.



Tags:

Best Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @Jill Freuden

    Instead of using a Bar Chart, what about using a Pie chart instead? Pie charts are always out of 100%. You could have it either be a semicircle or a full pie chart.

    It would change up the look quite a bit from your current presentation, but then you could play with putting the dates in different places.

    You may want to post in the Higher Education Community Group to see if others have additional ideas.

    Cheers,

    Genevieve

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Unfortunately there is no way to set how far out the axis goes on charts. Feel free to Submit a Product Enhancement Request when you have a moment as it would be great if we could.

    thinkspi.com

Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @Jill Freuden

    Instead of using a Bar Chart, what about using a Pie chart instead? Pie charts are always out of 100%. You could have it either be a semicircle or a full pie chart.

    It would change up the look quite a bit from your current presentation, but then you could play with putting the dates in different places.

    You may want to post in the Higher Education Community Group to see if others have additional ideas.

    Cheers,

    Genevieve

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Unfortunately there is no way to set how far out the axis goes on charts. Feel free to Submit a Product Enhancement Request when you have a moment as it would be great if we could.

    thinkspi.com

  • Jill FreudenJill Freuden ✭✭✭✭✭

    Thanks to both of you for responding, I appreciate it. Genevieve, your idea is great and I'm going to hold on to it in case someone besides me notices the issue. Our Provost's Office really likes the big splash of red and how easy it is to compare campuses with the stacked bar. The pies look nice, but aren't quite as splashy and they are really shooting for obvious to show we're moving back to in person classes. Paul, I will definitely submit an enhancement request. Thanks for confirming that I haven't missed something.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.