How do I create a Floating Column Chart in Excel?
Can someone advise how I can create this chart in Excel? please.
regards
Sandy
RE: How do I create a Floating Column Chart in Excel?
To create a Floating Column chart you would first of all need to have 2 series of data that you wish to plot in your chart.
Select your data and create a Stacked Column chart via the Chart Wizard.
Select the data series that you wish to hide by double clicking.
On the Patterns tab, change Border to None and Area to None. Click OK.
The Data series will now be invisible, whilst the other data series will display and appear as floating on the chart.
Hope this helps
To learn more about charts in Excel please check the syllabus for our Intermediate course.
Thank You
Sandy