formatting dynamic chart titles

[Rick Campbell]

When I set up a dynamic chart title, none of the formatting comes across.

I would like to take the following chart title, which is on two lines and
format the first part, up to the colon with
Bold
Size 10

After the colon
Regular
Size 8

Second line
Regular
Size 8
Color red

County Homes: Prices vs. Sales
(3-month moving average-($000's)

TIA

Rick

 

[Eric]

Rick,

I don't know if this is the best solution, but I do
something like this in a spreadsheet of mine. However,
for each part of the dynamic title that I have in a
different font or color, I have created a separate text
box.

The only problem is that if the titles change drastically,
I have to realign the text in relationship to the other
text boxes.

Not perfect, but it does what I need.

HTH

Eric

 

[Rick Campbell]

Eric,

There's no need to go that far because one can do all the formatting within
the title box. I can do it by hand. But with 100s of charts that gets
tiresome.

 

[Rick Campbell]

Here's the formula. How do I format it?

=O4 &" "& Q1 &" "& Q2