#### Related Topics:

Question about Harvard ChartXL 3.0 (163103)

# Stacked Bar/Column chart with Negative Values

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!

Posted by on

### Anonymous

Use a line chart instead with up/down bars

Posted on Oct 16, 2007

×

my-video-file.mp4

×

## Related Questions:

### I need to take the 2 year average of 2014 to 2015. How would i do this?

Average is total divided by count. So add up all the values for the two years and divide by 24 months. You could also just select the entire column of values and Excel will show the average in the status bar at the very bottom. If not, right click the status bar and select Average.

### How to make tally charts on my laptop?

To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

these are the steps involve
-select the data to be use for graph.include the column and row label in sections
-select data
-click on number tab
-click on text
-click ok
-click on chart wizard icon on the tool bar
or
click on insert on menu bar
click on standard tab or custom types tab
under chart type list ,click to select the desire chart type eg tally.
under chart sub -type list,click to select the chart desire.
click on next button.
click on data range tab under series to select rows or columns.
click on next button.
that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you
Oct 07, 2010 • Computers & Internet

### What's data series in excel

When you are creating charts in Excel a data series refers to the sets of values that are going to be on the chart, be it a line chart, a bar chart, a pie chart etc. Different types of charts can work with different kinds of series. If you select the data you want to chart, and use the Chart Wizard, it will detect what data you have chosen and define it into series for the purposes of being on the chart. You can do things like give names to the series or set colours for them or put titles and legends on the charts for them, and lots of other things. When you are working with a chart, a Chart menu will appear on the menu bar and there are options in it to do things with the different series that are in it.

Mar 12, 2010 • Dell Computers & Internet

### How do i find the variance if i'm given the x

Hello,
Set the [Mode] to [3:STAT]. You are offered the choices
1:1-Var
2:A+BX
3:__+cX^2
etc.
If you want to do 1-Var statistics, you press 1:1-Var. A column template opens where you put the X values. If a value is repeated you enter it several times. (there is no frequency column.)
When you enter all data you press [SHIFT][STAT]

You have several choices among them
4: SUM to get SigmaX^2 and Sigma X
5: VAR to get n, the mean X bar, the sample and population standard deviations
6:MINIMAX to get MinX and MaxX
7: Distr the Distributions.

If you want to perform 2-Var statistics
You press [MODE][STAT] and select one of the Regression models
2:A+BX
3:__+cX^2
etc.
The selection of any of the 7 regression models, opens a two-column template where you enter the X and Y values
When finished press [SHIFT][STAT]
The choices offered are
1. Type takes you back to select type of statistics to perform
2. Data To edit the data in the columns
3. Edit To insert or delete a value
4. SUM To access the calculated values of SigX^2,SigX,SigY^2,SigY,SigXY,SigX^3, SigX^2Y, SigX^4
5. Var : To access the calculated values n, Xbar, Sample STD for x, S STD for Y, Pop STD for X, and Pop STD for Y
6. MinMax : MinX, MinY, MaxX, MaxY
7. Reg: Gives you the regression coefficients for the particular regression model you want to test.
The mean is represented by X bar.
The variance is the SQUARE of the Standard Deviation.
Hope it helps.
Nov 06, 2009 • Casio fx-300ES Calculator

### My wife accidently deleted the overall grade column on her Easy Grade Pro (version 3.6). How do we restore this coulmn. Right now the overall grade does not show up on the score chart screen. We have...

try left clicking on the bar where it says __ out of ___ students. you should be able to add a new column. then left clicking on that column you can change it to overall grade in the main grade menu option.

### Ms-office

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
1. =A1-A2
2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

### Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.
Sep 30, 2008 • Microsoft Excel for PC

### Unable to create chart in excel

Check the source data that it is using to create your chart (right-click choose SOURCE DATA). The result you're getting sounds as if it may not include all the data you want to chart. Generally should include at least two rows AND at least two columns.
Nov 16, 2007 • Computers & Internet

### Excel

i have 2 columns in an excel. One column has data like a,b,c,d,e,f,g,h,i,j,k,l and the other column has values like 0,1,2,3,0,0,0,0,0,5,8,0 respectively. Now i have to generate a graph(pie chart and column chart). But the graphs should not have data and values that have 0 values. i.e, the graph should contain these data and values respectively. data: b,c,d,j,k values: 1,2,3,5,8.

1,418 views

Level 3 Expert

Level 3 Expert