Results 1 to 3 of 3

Thread: remove date and title from Chart and place above chart

  1. #1
    Junior Member
    Join Date
    Jan 2014
    Posts
    2
    Rep Power
    0

    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
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    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
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Jan 2014
    Posts
    2
    Rep Power
    0
    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

Similar Threads

  1. Change Chart Title According To Source Data Selection
    By terrybloome in forum Excel Help
    Replies: 4
    Last Post: 12-02-2013, 03:19 PM
  2. Custom Charts in Excel :: Gauge Chart (aka Dial/Speedometer Chart)
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 08-07-2013, 05:16 PM
  3. Replies: 2
    Last Post: 05-26-2013, 03:41 PM
  4. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  5. Replies: 1
    Last Post: 05-20-2012, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •