MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

2-line title on a xy line plot

  Asked By: Franklin    Date: Dec 31    Category: MS Office    Views: 1719

Is it possible to code a 2-line title into an XY line plot? I'd like
the lines to be different font sizes - the first larger than the



2 Answers Found

Answer #1    Answered By: Geldefsman Bakker     Answered On: Dec 31

Easy as pie. Manually:

1. Click on title, wait, click on title  again -- not a double-click
2. Move the cursor to the end of your first line  and hit enter
3. Highlight the first line and increase the font
4. Escape out and you're done

Using VBA, something like this:

ActiveSheet.ChartObjects("Chart 1").Activate
Selection.Characters.Text = "Line 1" & Chr(10) & "Line 2"
Selection.Characters(Start:=1, Length:=6).Font.Size = 20
Selection.Characters(Start:=8, Length:=6).Font.Size = 10

Answer #2    Answered By: Von Fischer     Answered On: Dec 31

I don't think I need to tell you that I really
appreciate your help!

Didn't find what you were looking for? Find more on 2-line title on a xy line plot Or get search suggestion and latest updates.