+ Reply to Thread
Results 1 to 5 of 5

Bars on Chart Display are Wrong

  1. #1
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Bars on Chart Display are Wrong

    Hi all,
    So here I am working away at finalizing a survey for this charting tool I have created. I opened my tool to give it one last check before I send it to 6 co-workers to get their impressions on it. Everything has been working well with it but this morning, when I picked the bars option to display bars on one graph, all of the bars are so narrow that they look like one (I had 5 series' selected). Can anyone tell me why? I've attached the version I will be sending around but if you know of some way that I can program the bars to be a certain width, I would like that. Thanks.

    Michael

    Edit, I should attach the file!
    Attached Files Attached Files
    Last edited by Mordred; 03-11-2011 at 10:38 AM.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

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

    Re: Bars on Chart Display are Wrong

    Thin columns normally indicates a category axis is being plotted as dates.
    Set the axis to be Text rather than Automatic, via the Chart Options dialog.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Bars on Chart Display are Wrong

    Thanks Andy, the x axis was set to Automatic but where is the option for Text? I have 3 options, Automatic, Category, and Time-scale.

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

    Re: Bars on Chart Display are Wrong

    Use Category.

    Text is the xl2007 term.

  5. #5
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Bars on Chart Display are Wrong

    Thank you very much Andy.

+ 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