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!

Ad

0helpful

1answer

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.

Sep 16, 2015 •
Microsoft Office Excel 2007

2helpful

1answer

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

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

2helpful

1answer

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

2helpful

1answer

Hello,

Set the [Mode] to [3:STAT]. You are offered the choices

1:1-Var

2:A+BX

3:__+cX^2

etc.

I**f 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.

I**f 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

The variance is the SQUARE of the Standard Deviation.

Hope it helps.

Set the [Mode] to [3:STAT]. You are offered the choices

1:1-Var

2:A+BX

3:__+cX^2

etc.

I

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.

I

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

- T
**yp**e takes you back to select type of statistics to perform **Data**To edit the data in the columns**Edit**To insert or delete a value**SUM**To access the calculated values of SigX^2,SigX,SigY^2,SigY,SigXY,SigX^3, SigX^2Y, SigX^4**Va**r : To access the calculated values n, Xbar, Sample STD for x, S STD for Y, Pop STD for X, and Pop STD for Y**MinMax**: MinX, MinY, MaxX, MaxY**Reg**: Gives you the regression coefficients for the particular regression model you want to test.

The variance is the SQUARE of the Standard Deviation.

Hope it helps.

Nov 06, 2009 •
Casio fx-300ES Calculator

0helpful

1answer

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.

Sep 20, 2009 •
Orbis Software Easy Grade Pro (EGPSING-W)...

1helpful

3answers

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

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

- =A1-A2
- =SUM(A1,-A2)

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

Jul 08, 2009 •
Microsoft Office Excel 2003 for PC

0helpful

2answers

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.

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

0helpful

1answer

Hi Have a look below

http://outdoorcooking.manualsonline.com/manuals/mfg/maytag/

http://outdoorcooking.manualsonline.com/manuals/mfg/maytag/

May 26, 2008 •
Dryers

0helpful

1answer

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

0helpful

1answer

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.

Sep 23, 2007 •
Microsoft Office Standard for PC

1,418 views

Usually answered in minutes!

×