Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart - extra dates are appearing (2003)

    My chart is a stacked bar chart. The source data is dates (Jan 1 - Jan 31), and these dates do not include weekends. But, when I create the chart, it inserts weekend dates into the chart. How can I get the chart to use just the weekday dates that I have in my source data?

    Also, I want the data labels to appear just to the right of the bars, not directly on them, because some of the data points are so small that you can't see the labels. I know I can move the labels one at a time, but I want to know if there is a faster way.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart - extra dates are appearing (2003)

    Click anywhere on the chart.
    Select Chart | Chart Options...
    Activate the Axis tab.
    Select Category instead of Automatic or Time Scale for the Category (X) axis.
    Click OK.

    Download and install Rob Bovey's free XY Chart Labeler.
    It has an option to move all data labels at once.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart - extra dates are appearing (2003)

    wow. How simple is that. Thank you!!

Posting Permissions

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