99.2% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
excel.training.course.london - How do I create a Floating Column Chart in Excel?
Resolved · Low Priority · Version Standard
How do I create a Floating Column Chart in Excel?
Can someone advise how I can create this chart in Excel? please.
For upcoming training course dates see: Pricing & availability
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.
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.
Quick Absolute Cell References
When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).