Dynamic Chart Titles
- Thread starter JayDee
- Start date
NARAYANK991
Excel Ninja
Hi ,
Your question is a very simple one , and you should have got your answer within minutes ; if it has still not been answered , one of the reasons is that you have uploaded an Excel worksheet which contains a picture of your chart , instead of the data and the chart itself.
If you cannot upload your actual workbook , you can wait till someone decides to answer your question.
Narayan
P.S. Entering :
excel chart title dynamic
in Google gives several results , one of which is here :
http://www.exceldashboardtemplates.com/how-to-make-an-excel-chart-title-to-change-dynamically/
Your question is a very simple one , and you should have got your answer within minutes ; if it has still not been answered , one of the reasons is that you have uploaded an Excel worksheet which contains a picture of your chart , instead of the data and the chart itself.
If you cannot upload your actual workbook , you can wait till someone decides to answer your question.
Narayan
P.S. Entering :
excel chart title dynamic
in Google gives several results , one of which is here :
http://www.exceldashboardtemplates.com/how-to-make-an-excel-chart-title-to-change-dynamically/
JayDee
New Member
Wow -I just needed that little bit of Help !
Tried the Template first, but I think I had a 'Screw-up' in my original Title, so had difficulty with it - so decided to simply follow Hui's advice
After a couple of false starts, I wrote the Formula I needed in a separate cell, then followed his method, and 'Hey Presto !'
I have been trying to get this right for a long time, so am very grateful !
To make the Formula I needed, I had to use 'Append - & etc, but I have noticed that different colours in Append does not seem to be possible. Is there a way of doing this to produce kWh as follows - in the Chart Title: [KISAUNI is just my House Name !]: Here is the Formula text !
" . . . JUNE 2015 - kWh_SUN 'square' to 'KISAUNI' . . . . "
Double thanks for a Solution, which again, I have tried to do for some time!
Many thanks anyway !
John Barrow
Tried the Template first, but I think I had a 'Screw-up' in my original Title, so had difficulty with it - so decided to simply follow Hui's advice
After a couple of false starts, I wrote the Formula I needed in a separate cell, then followed his method, and 'Hey Presto !'
I have been trying to get this right for a long time, so am very grateful !
To make the Formula I needed, I had to use 'Append - & etc, but I have noticed that different colours in Append does not seem to be possible. Is there a way of doing this to produce kWh as follows - in the Chart Title: [KISAUNI is just my House Name !]: Here is the Formula text !
" . . . JUNE 2015 - kWh_SUN 'square' to 'KISAUNI' . . . . "
Double thanks for a Solution, which again, I have tried to do for some time!
Many thanks anyway !
John Barrow
JayDee
New Member
Hi Hui,
I may be asking a bit too much, but I attach a Pic of my Personal SOLAR system Sheet (part of a suite of Sheets to track Production results !)
I currently need to be able to pick Data in a variable range, in order to lengthen and shorten the Times & Data shown in the relevant Charts. As you will note, there is a fairly complex extraction system I have devised - which is probably very amateur indeed - BUT actually works very well !
My constant aim is to Automate & Simplify, but to date, I have not been able to enter Chart formulas which will pick up the variable data (potentially every Month)
If you think it may be possible to Automate data ranges in the way I need, and can give me a steer, I will be most grateful. I cannot programme in VBA at all !
Regards
JOHN
I may be asking a bit too much, but I attach a Pic of my Personal SOLAR system Sheet (part of a suite of Sheets to track Production results !)
I currently need to be able to pick Data in a variable range, in order to lengthen and shorten the Times & Data shown in the relevant Charts. As you will note, there is a fairly complex extraction system I have devised - which is probably very amateur indeed - BUT actually works very well !
My constant aim is to Automate & Simplify, but to date, I have not been able to enter Chart formulas which will pick up the variable data (potentially every Month)
If you think it may be possible to Automate data ranges in the way I need, and can give me a steer, I will be most grateful. I cannot programme in VBA at all !
Regards
JOHN