excel.training.course.london - how do i create
Book Your Virtual Classroom Training
Hide

TrustPilot

starstarstarstarstar Excellent

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.training.course.london - How do I create a Floating Column Chart in Excel?

resolvedResolved · Low Priority · Version Standard

Fri 23 Nov 2007, 10:31 replyReply Trainer 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

For upcoming training course dates see: Pricing & availability

Fri 23 Nov 2007, 10:46 replyReply Trainer 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

 

Live dates & prices

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

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).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


TrustPilot
TrustScore 4.8 / 5       1272 reviews