Excel Chart Question

[bcooney]

I don't want to go to an Excel forum. I know one of you is an Excel wiz, too.

My problem is this: I have a simple bar chart of participants by type. It needs to be on its own page (not on the worksheet next to the data source). I would like to put the grand total of participants on the chart. I am currently just typing it in using a text box. Anyone?

[bcooney]

122 Views, 0 Responses!

[hall312]

Ms. Cooney,

Is the attached file similar to what you are looking for?

excel_test.zip

[bcooney]

Um, yes! How did you get this to work? I still can't see how a text box can contain a formula.

[hall312]

In excel, any cell or text box can contain a formula by typing “=” first, then the formula. If you would like that formula to reference another sheet within the same workbook, reference that sheet by using the sheet name followed by “!”. Cells on other sheets are preceded by “$”

Example:

=Sheet1!$B$9 typed into a cell or text box will reference sheet 1, cell B9

So in your example, have the total calculation do the addition of members on the sheet where the data is stored. Then on your graph sheet type the calculation to reference that cell. Easiest way is to just type the “=” in the formula bar and click the sheet you want and the cell, press enter. No typing necessary!

[bcooney]

I had no idea that a text box could contain a formula. I'm a bit embarrassed to not know something so basic, but how nice that it is so easy. Thanks.

[hall312]

As many questions (embarrassing or otherwise) that I've seen you answer (including my own), you have every right to ask any question you want. I'm just glad I could provide a little something back. :laugh2: