Results 1 to 5 of 5

Missing column from column clustered chart

This is a discussion on Missing column from column clustered chart within the Excel Questions forums, part of the Question Forums category; I will be glad if anyone can help me recover the missing column from my column clustered chart. Moreover, how ...

  1. #1
    New Member
    Join Date
    Oct 2014
    Posts
    15

    Default Missing column from column clustered chart

    I will be glad if anyone can help me recover the missing column from my column clustered chart. Moreover, how do I get the legend under the title using VBA. Thanks


  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    17,562

    Default Re: Missing column from column clustered chart

    I will be glad if anyone can help me recover the missing column from my column clustered chart.
    See if the following link helps...

    Broken Y Axis in an Excel Chart - Peltier Tech Blog

    Moreover, how do I get the legend under the title using VBA.
    Try...

    Code:
    chart.SetElement msoElementLegendTop
    Hope this helps!
    Last edited by Domenic; Feb 23rd, 2015 at 07:02 PM.
    Domenic Tamburino
    Microsoft MVP - Excel
    xl-central.com - "For Your Microsoft Excel Solutions"

  3. #3
    New Member
    Join Date
    Oct 2014
    Posts
    15

    Default Re: Missing column from column clustered chart

    Domenic, thanks for the help. In regards to my first question, I talking about one of the bar not showing up when I add the Line Markers chart. Please see below the chart without the line markers.


  4. #4
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,365

    Default Re: Missing column from column clustered chart

    Format the horizontal axis, make sure the setting for 'Axis Crosses' or 'Axis Position' is 'Between Tick Marks'.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  5. #5
    New Member
    Join Date
    Oct 2014
    Posts
    15

    Default Re: Missing column from column clustered chart

    Thanks Jon, fixed now.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com