# Creating a Dual-Axis Scatterplot in Quicksight to Compare Actual vs Scheduled Time

**URL:** <https://community.amazonquick.com/t/creating-a-dual-axis-scatterplot-in-quicksight-to-compare-actual-vs-scheduled-time/32448>\
**Category:** Q&A\
**Tags:** visuals, calculations, Business-Intelligence-Engineer, formatting, quick-sight\
**Created:** [July 10, 2024, 6:40pm UTC](https://community.amazonquick.com/t/creating-a-dual-axis-scatterplot-in-quicksight-to-compare-actual-vs-scheduled-time/32448 "2024-07-10T18:40:17Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Nico](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/nico/32/32113_2.png) [@Nico](https://community.amazonquick.com/u/Nico)\
**Post date:** [July 11, 2024, 6:13am UTC](https://community.amazonquick.com/t/creating-a-dual-axis-scatterplot-in-quicksight-to-compare-actual-vs-scheduled-time/32448/2 "2024-07-11T06:13:26Z")

</div>

Hi @Nitish_reddy ,

I see two topics here, you need a dual axis, and you want a gantt chart. Both features are not available in quicksight yet. Both are great #feature-request .

Lets talk about possible workarounds.  
To receive a gantt chart, you can use stacked bar charts, meaning you fill the empty space between with bars and hide them by giving them the background color. For a more detailed description:

> [@Gantt Chart Visualization Type](https://community.amazonquick.com/t/gantt-chart-visualization-type/842/2):
>
> First, I want you to know that QuickSight team has received requests to introduce Gantt chart from other customers as well. It might be added in 2022. For the time being, you can get results similar to the image below Steps: Create a calculated field called MinDate with expression similar to “minOver(min({Start Date}), [])”. Value of this field will be equal to the earliest date you have in your dataset. Create a calculated field called Empty Period wit…

Next step issue is the dual axis. What you can do is overlay two charts in your dashboard. Make sure the scale of your axis is the same.

Best regards,  
Nico

---

_[View the full topic](https://community.amazonquick.com/t/creating-a-dual-axis-scatterplot-in-quicksight-to-compare-actual-vs-scheduled-time/32448)._