If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table within a chart
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. |
#2
|
|||
|
|||
Table within a chart
I forgot to add that I'm using Excel 2003.
-- Catherine "Catherine" wrote: 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. |
#3
|
|||
|
|||
Table within a chart
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Catherine" wrote: 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. |
#4
|
|||
|
|||
Table within a chart
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! -- Catherine "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Catherine" wrote: 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. |
#5
|
|||
|
|||
Table within a chart
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 |
Thread Tools | |
Display Modes | |
|
|