+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 - Odd problem with chart data table

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Exclamation Excel 2007 - Odd problem with chart data table

    Excel 2007
    Windows XP Professional

    Whenever I add a data table to an existing chart, I end up with two sets of labels for the chart. See example at following link:

    http://i1203.photobucket.com/albums/...bleProblem.jpg

    If I delete the upper set of labels, the data table labels aren't perfectly lined up with the marks on the chart. See example at following link:

    http://i1203.photobucket.com/albums/...leProblem2.jpg

    Excel 2003 did really well with having the data table attached to the chart. Excel 2007 does a horrible job, at least for me. Every video I've seen on YouTube shows that it can be done correctly, but for some reason, my copy has issues.

    I'd appreciate any insight some may have on what is causing this. Given that I produce a minimum of 50 charts a month, many with data tables, this is extremely frustrating!!

    Any help is greatly appreciated!
    Rita Brasher
    Project Engineer
    FedEx Express / IPEG Clearance Analytics and Training

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Excel 2007 - Odd problem with chart data table

    How is the alignment if you sent the Axis labels to none rather than delete the axis?

    Or if you change the axis type to Text rather than automatic or date the labels will be removed and the table header row used.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2007 - Odd problem with chart data table

    I set the axis to "Text" and it worked like a charm! Thanks, Andy!!!

  4. #4
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2007 - Odd problem with chart data table

    So..... my fix stopped working. Now I'm back to the exact same results I had before and changing to "Text" does nothing! I'm sooooooooooo tired of dealing with Microsoft. What was wrong with 2003???? NOTHING, THAT'S WHAT!! They've made Office so difficult to manage. What used to take only a right-click to accomplish now takes jumping through numerous hoops. Sigh...

  5. #5
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2007 - Odd problem with chart data table

    Ok, soooo, I realized my issue was the fact that I had two Y axes. I had a number on the left and a percentage on the right. When I swapped the axis each series referenced, it lined the data table up correctly. What a load of garbage!!!

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: Excel 2007 - Odd problem with chart data table

    RitaB,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  7. #7
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2007 - Odd problem with chart data table

    Quote Originally Posted by arlu1201 View Post
    ritab,
    "don't post a question in the thread of another member -- start your own thread."
    this is my thread!!!

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Excel 2007 - Odd problem with chart data table

    Hahahaha. This is rather funny... Not only is the thread 9 years old.... but it has taken you 9 years to object to arlu's message... and even arlu herself vanished from the forum years ago!!!!
    Glenn



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1