# Create Stacked Bar Chart to report on Estimated and Actual hours

**URL:** <https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161>\
**Category:** Ask the Community\
**Created:** [17 July 2024 15:09 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161 "2024-07-17T15:09:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shruthi](https://luna1.co/8d76cd.png) [@Shruthi](https://forum.asana.com/u/Shruthi)\
**Post date:** [17 July 2024 15:09 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161/1 "2024-07-17T15:09:52Z")

</div>

Hello Everyone,

I see an option called Stacked Bar chart in Asana dashboards but its not allowing us to report on Estimated and Actual hours.

Note: Estimated and Actual hours are roll up field values in Project level from tasks.

And also why can’t we see all the custom field options in Asana gadgets?

It has become very tricky to build a dashboard just to show how much time we estimated and how much we Actually spent in one gadget view (rather than having multiple gadgets).

Does anyone have a workaround or solution?

Thanks,  
Shruthi SJ

---

<div class="post-metadata">

**Author:** ![Stephen\_Li](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/stephen_li/32/279555_2.png) [@Stephen\_Li](https://forum.asana.com/u/Stephen_Li)\
**Post date:** [18 July 2024 01:42 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161/2 "2024-07-18T01:42:20Z")

</div>

@Shruthi - what is your intended outcome? Stacked bar charts are a new feature that are best used when you want to measure task data grouped along two axes (e.g., count of tasks by their owner and a custom region field).

From what you’re describing, it sounds like you might want to use a formula field to tab the difference between actual and estimated time on each task, then perhaps group these by their assignee and maybe a custom field?

If you can give more context for what you want and what you’ve already tried, that would be helpful.

---

<div class="post-metadata">

**Author:** ![Shruthi](https://luna1.co/8d76cd.png) [@Shruthi](https://forum.asana.com/u/Shruthi)\
**Post date:** [18 July 2024 08:44 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161/3 "2024-07-18T08:44:06Z")

</div>

Thanks for your response, The requirement here is to show what is the Estimated Hours v/s Actual logged hours in a task/project against Assignee. As i mentioned right now in Asana this is possible with different gadgets (please see the screen shot) but what we wanted to show is in one single stacked bar chart (attached a screen shot called expected outcomes).

And also my another question was, why can’t we see all the custom fields in Asana dashboard gadgets.

 ![ActualvsEstimated](https://us1.discourse-cdn.com/asana/original/3X/4/1/41665168e4096c2887a1ad0e07e947b78acc4ca8.jpeg)

 ![Expected_Outcomes](https://us1.discourse-cdn.com/asana/original/3X/0/e/0e22740a8a61f85fb0d292a7c5f6501fbe2e8dd4.jpeg)

---

<div class="post-metadata">

**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\
**Post date:** [18 July 2024 11:34 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161/4 "2024-07-18T11:34:47Z")

</div>

Stacked Bar charts are apparently being rolled out, we’ve seen clients show us, so maybe wait a few days and test again!

---

<div class="post-metadata">

**Author:** ![Emily\_Roman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/emily_roman/32/283076_2.png) [@Emily\_Roman](https://forum.asana.com/u/Emily_Roman)\
**Post date:** [5 August 2024 07:00 UTC](https://forum.asana.com/t/create-stacked-bar-chart-to-report-on-estimated-and-actual-hours/864161/5 "2024-08-05T07:00:43Z")

</div>

Closed on 5 August 2024 07:00 UTC

This topic was automatically closed after 13 days. New replies are no longer allowed.
