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?
 
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

All Courses

From novice to tech pro — start learning today.