Pie Charts

I was eager to checkout the recently released Smartsheet Charts, I have produced a couple of Pie Charts based on some real time data but seem to have found that limited funtionality/formatability (e.g. Not able to re-position labels) restrict their actual use, please see screenshots below. I wondered if it's just me or have others discovered the same?

SS PIE Chart - example2.JPG

SS PIE Chart - example1.JPG

Find more posts tagged with

Reports

Dashboards

Comments and Conversations

Comments

Sasan

Tim,

Yes, in v1, there are basic formatting capabilities for pie charts. There are certainly many more formatting enhancements that can be added in the future. One enhancement can be the ability to call out data values outside of each slice. In the mean time, we recommend couple of alternative options that may be even better for your viewers given best practices in charting and especially for mobile view:

Use Column or Bar charts, when slices are too small or very close in size. This is also a best practice in charting.
Shorten your data values (from £9,221,183 to £9.2) and then add (£million) in your chart title. Brevity is also a best practice in charting.
Given that your viewers can also see the data value as a tool tip by hovering over the slice, you can also turn off the slice labels.

Hope these tips help. We greatly appreciate your feedback.

Thanks

Sasan

Tim

Sasan, Thank you for the useful suggestions/workarounds.

It's unfortunate that all involve a compromise from the customer's perspective, data would need to be input into my sheets in that format (9.2) which is not useful, again highlighting limited functionality (Excel charts, units can be selected, regardless of inputted units).

The choice of chart is determined by an end users preference, small slices (in other charting tools can be exploded to show detail)

Although I'm an advocate of using SS as intended, e,g not on printed material, a tool cannot be designed so as to discount the need to present printed material and hence negating hover text.

Perhaps the Community can be made aware of intended changes for v2.

Thanks

Tim.

Sasan

Tim,

Completely understood and valid. We will consider your feedback in future releases.

Thanks

Sasan

Stacey Carrasco

@Sasan Any update to the Pie Chart features? I sure doesn't seem to be the case because I ran into this issue recently where our team wanted to see a pie chart rather then any other chart.

Pam Dunn

@Sasan Not sure if this it the right place to ask. Why does the system not allow the choice of a pie chart when I just created same chart as a pie chart with similar data? If I don't' have any values over 0 in my source data is this why? Weird I should be able to start out with a pie chart and it populate with data as work is being assigned and performed resulting in the status changes.

This is my dilemma.

In example on top a proofer is assigned, but none of the jobs have been approved check box not checked.

Example on bottom. A person hasn't been assigned to the Priority 3 jobs and the check box is not checked. I don't have the choice to choose a pie chart when building the widget resulting in a line chart option instead.

Sign in to join the conversation!

Quick Links

Trending discussions

Unable to reply to comment with "Edit by Anyone" Publish Option toggled on
Hello! Please help me settle a debate: If a sheet is set to publish and it's set to editable by anyone, can a viewer reply to an email to post a comment? OR do they have to always access the publish link directly to respond to the comment? Someone's "Viewer" collaborator on an asset is receiving a "Your recent reply…
Is it possible to send emails to form submitters?
I have a public facing form and was looking to provide an automated response to the form submitter, but the submitter is not part of our organization/part of contact list. I would like to use the e-mail address they provide to send an answer. Hopefully with the document attachment that is created automatically through…
Can I have a form create new sheets with each submission?
Hello! I am trying to create a form that everyone on my team can use to gather contact information from clients. The preference would be for each form submission to create a new sheet since each one would be for a different client. We found that Microsoft Forms will allow us to do this, but it doesn't look as polished. Can…