remove date and title from Chart and place above chart

[H_Kennedy]

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

[Admin]

Hi

add this line
OnSheet.Range("h3").Value = Me.GroupName & ComboBox1.Value & " Summary" before
If blnMadeChart Then

Also comment these lines from the CreateChart procedure


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

[H_Kennedy]

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