Table within a chart

[Catherine]

I have a stacked column chart with data for each month of the year. This
chart is updated monthly. I want to add to the side of the chart a YTD total
that will get automatically updated monthly. Does anyone know how to do this?
Thank you.

 

[Catherine]

I forgot to add that I'm using Excel 2003.

 

[Shane Devenshire]

Hi,

In the spreadsheet set up a formula that returns the amount you want. We
don't know anything about your data layout, so lets suppose the formula is in
C2, what ever that formula is.

1. Select the chart.
2. Click the Formula Bar and type = (the equal sign)
3. Click on the cell with the formula, here C2.
4. Press Enter.
5. Drag the text box that was just created anywhere you want on the chart.

Suppose the formula were something like =SUM(A2:A13), you could modify it to
read
="YTD Total: "&C2
this would show on the chart as YTD Total: 123.45 or something similar.

 

[Catherine]

Shane:

This is close to what I want. I had started with text boxes. The cell I want
to reference is in another worksheet so I have in the text box something like

=Referrals!$N$2

This works but I'm having a hard time having the two text boxes align to read:

YTD Referral = 25

with 25 being the formula text box.

I like your idea of having one text box saying YTD Referral = 25. I tried it
using

="YTD Referral ="&Referrals!$N$2

I get an error message. Do you know why? How can I get text withing a formula?

Thank you!

 

[Ed Ferrero]

Hi Catherine,

I like your idea of having one text box saying YTD Referral = 25. I tried
it
using

="YTD Referral ="&Referrals!$N$2

I get an error message. Do you know why? How can I get text withing a
formula?

You have found one of the limitations of Charts in Excel.

Get around it by putting the formula ="YTD Referral ="&Referrals!$N$2 in a
cell on your sheet
and link the text box to that new cell.

Ed Ferrero
www.edferrero.com