Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel.training.course.london - how do i create

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?

ResolvedVersion Standard

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

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.