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!
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!