| View previous topic :: View next topic |
| Author |
Message |
Mike_15
Newbie
Joined: 28 Mar 2012
Posts: 1
|
 Posted: Wed Mar 28, 2012 7:56 am Post subject: Excel Stacked Column Chart |
 |
|
Hi,
I was wondering if anyone knew how to create a stacked column chart in excel that is a little tricky. My total column is one number, let's say 1%. I have three different color stacks with larger numbers, let's say 1.3%, 1.2% and 1.4%. Is there anyway to represent these numbers within the 1% respectively without exceeding the 1% total column?
Thanks,
Mike |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Mar 28, 2012 8:31 am Post subject: |
|
|
Err, this is a OpenOffice.org Writer forum not an MS Excel forum. You may be in the wrong place.  If you mean OOo Calc, you should be in the Calc forum.
At the moment I don't understand what you are trying to achieve. You have those three percentages, 1.3%, 1.2% and 1.4%. Are you saying that they sum to 1% in that 1% bar?
A bit of sample data would really be helpful. You could post some here or even better post it somewhere like [url = www.mediafire.com[/url] MediaFire [/url]
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
