How Do You Create A Waterfall In Excel 2010?

Can you add a secondary axis to a waterfall chart?

The waterfall chart has a bunch of series on the primary axis, but we'll add a new series for the secondary axis. Right click the chart, choose Source Data, and click on the Series tab. The chart now has a secondary axis. Format the secondary axis: right click on the axis and choose Format Axis.

How do you create a dual axis waterfall chart in tableau?

To make this dot plot and Gantt chart share an axis, click the second occurrence of the measure on the Rows Shelf and choose “Dual-Axis”. To ensure the dots line up with the ends of the Gantt bars, right click on the second axis and choose “Synchronize Axis”. From here, the rest is just formatting.

How do you create a waterfall in Excel?

  • Select your data.
  • Click Insert > Insert Waterfall or Stock chart > Waterfall. You can also use the All Charts tab in Recommended Charts to create a waterfall chart.
  • Leave a Comment

    Your email address will not be published. Required fields are marked *