-
Need help creating graph - reports late
I need to create a graph, for two different people, tracking to see if reports are done on time or not. I need to use the assigned to column and then the days late column. Negative were done early, 0 were done on time (Day Of), and then positive numbers will be late. Each graph would be just the one person, and then %…
-
Double Access Graph and using dates
it would be great if double access graphs would be available in Smartsheet like excel Also, can something be done with the dates, so you don't need to do a formula on your dates to be able to put them in order in graph. it's really annoying to have a 1 in front of your months to be able to get them to display…
-
Adding graph and counts to a dashboard
Hello there! I am looking to add to meeting dashboard. I have a sheet tracking our quarterly goals (seen below) and a dashboard for our weekly team meeting (also seen below) - what I would like to do is add a count of goal health per person- X amount of goals in the green, x in red, x in blue, etc. The summary of goals I…
-
Modifying the vertical axis on graph
I have created a stacked bar graph on a dashboard from a metrics sheet, for some reason the vertical axis is showing the values as 0, 1, 1, 2. I can't work out how to change this, any ideas?
-
Task totals across multiple plans & within a set timeframe
Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I want to look at a timeframe scale of the last 3 months and the next 6 months. The four departments are: Editorial, Design,…
-
Template Formatting For Graphs - Consistent Colors
Is there a way to keep the colors consistent for graphs. For example, I created a graph showing units by color, with columns. Right next to it, I created a pie chart using the same source data but the colors for each unit represented are different. I know I can change them to match, but what a pain to do this for all my…
-
Graph Axis Autoscale Double Counting on X-Axis
Hello, I have a graph showing the number of projects under certain teams/criteria. At the moment there is only 1-2 projects for each criteria. When using a bar chart, I am seeing the scale double count as per below. Has anyone seen this before and know the root cause? Grateful for any shared experience, Protonsponge
-
Logarithmic scale for chart widgets
When using Dashboard Chart Widgets, the charts look great if the data is within similar parameters for each row/column. However, if you have one row that has outlier data (see picture), then all the other rows are hard to visually see what's going on. The solution would be to allow for charts to have a logarithmic scale to…
-
Graph Axis
Hi, is there a way to alter the text in the category labels on a bar graph? I didn't think so but wanted to double check because I'm not sure why one graph is slanted text and the other is straight and overlapping.
-
Merged: Trend Line over Column Charts
This discussion has been merged.