-
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
-
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.
-
Is there a way to create a dashboard that will update weekly?
Right now I am sending out a weekly report, but am using excel and pivot tables. Some of the info on the report is YTD which is easy to set up, but other tables are only from the past week. Is there a way to set up graphs/tables that would update M-F weekly on their own? I don't want to pull from the last 7 days as that…
-
Milestone Trend Analysis (MTA) Chart creation on dashboard
Hello, I'm adapt/add a Milestone Trend Analysis (MTA Chart) on Smartsheet. Is there a way to reflect his on a dashboard. Here is a copy of what I would like reflected on our dashboards. Not my data but I saw this for usage with MSProject. I'm looking to have sheets with data and project/display this data on the dashboard…
-
Did stacked charts change?
Good afternoon, someone from my team has pointed out that they can no longer see both values on a chart just the cost is shown and the formatting is different. Did Smartsheet change the way the stacked charts are shown? This first screenshot is from September 2024 where it shows both the quantity and cost at the ends of…