remove date and title from Chart and place above chart

Hello

The VBA code creates a Chart with the Date at the Bottom and Title at the top.Can the Date and Title not be displayed in the Chart area but instead place above the Chart.I have highlighted in yellow where I would prefer the Date/Title to appear.Can the Title/Date + "Summary" appear exactly as in the excel 2010 file

Regards,

H_K

Hi

add this line

Code:

---

OnSheet.Range("h3").Value = Me.GroupName & ComboBox1.Value & " Summary"

---

before

Code:

---

If blnMadeChart Then

---

Also comment these lines from the CreateChart procedure

Code:

---

.HasTitle = True
.ChartTitle.Text = GroupName
.ChartTitle.Text = GroupName & vbLf & "" & DisplayDate

---

Very good..

How do I get "" marks around the single Letter so it appears as GROUP "A" 9-JAN-2014 and also a gap between the "A" and the date

Thanking you