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:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/PowerPoint/Q_28663374.html

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:

C1.jpg
Which creates the following chart

c2.jpg
Using the previous post, I make the following change:

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

c4.jpg
How can I fix this?

Thanks
Anthony LuciaAsked:
Who is Participating?
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:
Hello,

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

=B2-C2

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.

screenshot
See attached file.

cheers, teylyn
Q-28666355.pptx
0

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.