We help IT Professionals succeed at work.
Get Started

MS PPT - charts

234 Views
Last Modified: 2015-05-01
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
Comment
Watch Question
Finance Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 3 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE