Dynamic Chart Title With 3D Stacked Column Chart

T

Thomas M.

Excel 2007

I have a 3D stacked column chart that contains two data series. My data
looks like this:

Month Warnings Critical Incidents Misc Incidents
January 12 5 1
February 8 7 3
March 7 12 1

I would like to add a chart title that contains the current year. I would
like the year number in the title to update automatically. With a 3D
clustered column chart, I can do that by putting a formula in a cell, and
including that cell in the chart range. I can't seem to make that work with
the 3D stacked column chart. Is there any way to create a dynamic chart
title with a 3D stacked column chart?

Thanks for any help that you can offer.

--Tom
 
O

OssieMac

Hi Thomas,

Select the chart and the Chart Tools ribbon tabs will be displayed to the
right of the other Ribbon names.

Select the Layout tab.

Select Chart Title in the Labels block.

Select the option where you want the title to be displayed.

Highlight the default text in the chart title box.

Click in the Worksheet Formula bar.

Type = and then select the cell that contains the required chart title and
then press Enter.

Note that you can change worksheets when selecting the cell with the
required chart title.
 
T

Thomas M.

Perfect! Worked like a charm. I knew it was possible, but I'm more
familiar with Excel 2003 and I'm still learning where things are located in
Excel 2007.

Thanks for the help!

--Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top