Question about Harvard ChartXL 3.0 (163103)
I am having problems creating either a stacked bar or a stacked column chart using Harvard ChartXL vers. 3.02. I need to stack 3 different series/bars/columns. The software works fine if all 3 contain all positive or all negative values. However, when one or more of the series have opposite signs, the software automatically subtracts these values. Worst case scenario is if one series drops out completely after the calculations have been made. In Excel, a stacked column or bar will only stack same-signed series. Any series with an opposite sign from the rest will simply be plotted as is. So say in 1995, consumption = 5, investment = 3, but net trade = -2. In Excel you would see a bar up to 5 to represent consumption, then on top of that investment with a length of 3 for the total of two bars as 8. Trade will simply be plotted below the zero line showing a value of -2. In Harvard, it will stack consumption and investment and then subtract Trade. The whole bar will move two places down and only show consumption and investment to give a total of 6. We use these charts to specifically show the breakdown of components. Although the total may not be accurate if you have series with opposite signs, you can always add another series that shows simply the net impact of all three components. Easy fix! How can I get the same result in Excel with Harvard? I don't want to lose any components because it will give the impression that say trade did not have any impact at all when in fact it pulled the entire series down two places. The support team at Harvard gave me a very short answer of "not possible". This is such a basic chart that I am suspicious if there really is no way to produce such chart. HELP!
Tips for a great answer:
Sep 16, 2015 | Microsoft Office Excel 2007
May 26, 2008 | Dryers
Oct 07, 2010 | Computers & Internet
Mar 12, 2010 | Dell Computers & Internet
Nov 06, 2009 | Casio fx-300ES Calculator
Sep 20, 2009 | Orbis Software Easy Grade Pro (EGPSING-W)...
Jul 08, 2009 | Microsoft Office Excel 2003 for PC
Sep 30, 2008 | Microsoft Excel for PC
Nov 16, 2007 | Computers & Internet
Sep 23, 2007 | Microsoft Office Standard for PC
Mar 01, 2021 | The Computers & Internet
1,406 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: