MS-PPT: Overlapping bars on a chart using a stacked chart

I am using PPT 2013, and have no excel experience, and have not used the new style PPT charts.

I am trying to implement the following post:

In the post it says Excel is integrated with 2013 PPT.  I tried to  duplicate the solution in the post above, but was unable to.

I start with a new slide, and go to INSERT->CHART->STACKED COLUMN

I see the following image:

Which creates the following chart

Using the previous post, I make the following change:

But this creates the following chart, which is not quite what I was looking for:

How can I fix this?

Anthony LuciaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

it looks as if the formula in cell D2 is not calculating. The formula is still showing although another cell is selected.

You can also enter the formula as


and then copy it down.

As I understand from your other question, you only want two series in the chart. The first column of data just provides a base value for the calculation, but you don't want to plot it. Therefore, you need to remove that series from the chart.

You can do this by dragging the left border of the blue highlighted cells to the right, so only two series are included.

See attached file.

cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony LuciaAuthor Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft PowerPoint

From novice to tech pro — start learning today.