LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 68
Default Dynamic Chart Title With 3D Stacked Column Chart

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic chart title johnny Charts and Charting in Excel 2 August 6th 08 09:54 AM
Dynamic stacked column chart with ranking Bhupinder Rayat Charts and Charting in Excel 0 August 23rd 07 09:56 AM
Dynamic Chart Title? Kent McPherson[_2_] Charts and Charting in Excel 6 August 16th 07 08:48 AM
Dynamic Stacked Column Chart Help ksp Charts and Charting in Excel 2 June 20th 06 01:15 AM
Dynamic updating of chart title gerok Charts and Charting in Excel 2 September 14th 05 07:28 AM


All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"