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:
Usually answered in minutes!
Step 2: Please assign your manual to a product: