98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - How do I create a Floating Column Chart in Excel? | Excel forum
excel.training.course.london - How do I create a Floating Column Chart in Excel? | Excel forum
Resolved · Low Priority · Version Standard
Fri 23 Nov 2007, 10:31Trainer Sandy said...
How do I create a Floating Column Chart in Excel?
Can someone advise how I can create this chart in Excel? please.
regards
Sandy
Fri 23 Nov 2007, 10:46Trainer Sandy said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying Values Without Formulas in Excel 2010If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method: |
