dynamic graph updating (titles and size of source)

EllieCat

New Member
Joined
May 9, 2007
Messages
44
I'm hoping someone can help me.

Every month, a set of graphs is produced showing trend year to date from January. And every month I have to go through, update the source reference to include the new months data, and change the titles so they say "July" (I know it's september now, I run 2 months in arrears)

Is there any way to make the title of the chart a cell reference or formula? I tried deleting the title and having a dummy point I could add a data label to (using appspro x-y labeler) but couldn't find a way to expand the label to the full width of the chart (it seemed to cap at about 2 words in 20 point font and then wrapping to a new line)

On a similar time saving note, is there any way to set the source data up so that once there is data for July, it's displayed on the graph, without having large blank space after it?

Thanks in advance!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

EllieCat

New Member
Joined
May 9, 2007
Messages
44
Thank you Andrew, that's exactly what I need!

The one thing the examples don't cover is changing the title of the chart dynamically, any ideas if that's possible?

Thanks!
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Use a formula in a cell to return the title you want. Click the Chart Title, enter = in the Formula Bar, point at the cell containing your title and press Enter.
 

EllieCat

New Member
Joined
May 9, 2007
Messages
44
...You learn something new every day. I never noticed there was a formula bar on graphs, I've been trying to type "=" in the text box. :oops:

Thank you so much, and appologies for my blondeness.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,414
Messages
5,596,001
Members
414,037
Latest member
Roamingsmile

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top