Adding Total to a Chart

**graeme86** · 03-06-2007, 11:10 AM

On my chart i have a 14 columns X 2 rows of data and i have these charted but i need to add a total of all the data to the bottom of the chart if possible.

Thanks For any help that can be given.

Graeme

**oldchippy** · 03-07-2007, 08:30 AM

Hello there,

It’s not exactly clear what you are trying to achieve from the information given. But if you can provide a small zipped sample of your data, then hopefully a solution can be found.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this to your post.

**graeme86** · 03-07-2007, 08:36 AM

So this is the sample file. What i want to do is take the totals from cells B4,B5,B6 and show them on the chart somewhere also it would be nice if they update in real time.

**oldchippy** · 03-07-2007, 08:40 AM

OK, try this, open the Drawing toolbar, click on Text box, draw it on the graph where you want it, with the text box selected, then click in the formula bar, press = and click on B4 in your data sheet. You should now have that on your chart. Repeat for the other cells.