Dynamic Chart Title with different text format for each line

[Jose Alessandri]

Hello,
I need to create a dynamic chart title with 3 lines formatted differently. I have managed to create and insert the dynamic title, but I have not found a way to have different formatting on different lines.
Thanks for your help.

 

[NARAYANK991]

Hi ,

I am not sure but I doubt that you can.

For the chart title to be dynamic , it has to refer to a worksheet cell ; only the text from the cell will be taken , and the formatting will have to be done on the chart title itself ; this means that 3 separate lines of text cannot have 3 different formatting.

If the title were static text , you would be able to format each line of text differently.

Probably if you used VBA , you would be able to do it.

Narayan

 

[vletm]

Do You mean something like this?
Change 'Title' texts and press apply...
ooo ... You can change font's size, bold and color ...
This is example.
I just try to give an idea.
Okay.

 

[p45cal]

I have managed to create and insert the dynamic title

How are you doing this? Macros? Named ranges? Give us a clue then we can give an answer to suit.

 

[vletm]

Please, check 'Tools -> Macro -> Macro...'
There is a basic idea of 'how to do this'.
It isn't beautiful code at all, but it works.
Now, You have a way to do this, Okay?

 

[p45cal]

Please, check 'Tools -> Macro -> Macro...'
There is a basic idea of 'how to do this'.
It isn't beautiful code at all, but it works.
Now, You have a way to do this, Okay?

vletm, was this addressed to me? I was actually asking Jose how he 'created and inserted the the dynamic title'.

 

[vletm]

Both of You. Jose asked first and You can get the answer same time.