MS PPT - charts

I am using MS PP 2013

While I have done charts in much older versions of PPT, I have not done any charts in 2013

What I want to do is this:  Have a 3 bar chart with 2 values represented on each bar.  It is understood the first value will always be larger than the second, Given the following values:

    Red   Gold
    ---   ----
    100     90
     80     50
     50     20

Open in new window


And I want it to show the following, where '.' is red, and 'x' is gold

    |.|    
    |x|    
    |x|    |.|   
    |x|    |.|   
    |x|    |.|   
    |x|    |x|    |.|
    |x|    |x|    |.|
    |x|    |x|    |.|  
    |x|    |x|    |x|
    |x|    |x|    |x|

Open in new window


So only the part where the value of red exceeds the value of gold will be displayed as red, and the rest of the bar will be displayed as gold.

I looked at the charts available in PPT, but I do not see one that can perform that.  I go to Insert->Chart and see the following chart types:
Stacked Column and 100% stacked column, but these do not seem to do exactly what I am looking for.

Is what I am trying to do possible.  If so, what path should I take?

Thanks
Anthony LuciaAsked:
Who is Participating?

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

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

Dan CraciunIT ConsultantCommented:
Isn't it easier to make the chart in Excel and then paste it into Powerpoint?
I've always found the graph capabilities of PP lacking, like they were added as an afterthought.

HTH,
Dan
0
Rob HensonFinance AnalystCommented:
I suspect a stacked chart would literally stack the values, ie for line 1 you would get a 100 column and then a 90 block on top.

What you need is a third column giving the difference between the two, ie for line one you would have 100, 90 and 10. You would then do a stacked chart of the 90 and the 10.

As Dan says, much easier to do in Excel and then paste in.

Thanks
Rob H
0
Rob HensonFinance AnalystCommented:
Just had a play in PowerPoint 2010

When inserting a new chart, it opens an excel sheet to input the data. Default by looks of things happens to be 3 data series. I have entered the Red values for series 1, the Gold values for series 2 and a formula in Series 3

=[@[Series 1]]-[@[Series 2]]

This was entered by typing = and then selecting the cells, the table references were entered automatically so it looks like PPT 2010 uses an Excel table for its data.

I changed the chart type to stacked column and I got all 3 series in the chart so I have then hidden the column for Series 1 and it does not appear in the chart.

Thanks
Rob H
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Echo_SCommented:
PowerPoint uses Excel for its charting and has since 2007. You can do conditional formatting, etc, add formulas as Rob noted, etc. For this you shouldn't need to do it in Excel and paste it into PPT. You could, but why bother?
0
JSRWilsonCommented:
If you have a data sheet (in PPT) like this and choose to use only the relevant data (Select data) you will get this chart
Data sheet
Chart
0
JSRWilsonCommented:
Oh I missed Echo's comment but that's what I'm saying too!
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.