Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Blank Area Between Bars (2000)

    I have a bar chart that displays authorized and actual spending for 2002 and 2003 for each company division. I display the bars for both years above the division, that is the division name along the x-axis and dollars along the y-axis. My boss likes the display but would like to have a space between the years. He wants 2002 authorized, 2002 actual, space (no bar), 2003 authorized, 2003 authorized. How do I insert a space without creating another data element on the legend.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Insert Blank Area Between Bars (2000)

    Insert rows (or columns if data transposed) in your dataset for these "blank" entries. Put no data in them

    Steve

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Blank Area Between Bars (2000)

    Thanks, I guess good minds think alike. I already tried that plus more. I added a blank set of data and even changed the series name to " ". This inserts a space between the two other sets of column/bars. I still get a square in front of a " " in the legend box. How do I get rid of the reference in the legend box? I tried changing the color of the data set to no luck.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Insert Blank Area Between Bars (2000)

    In the legend box select the name and the symbol together (not just the marker!) and then delete it. If you select just the marker and delete you will eliminate the range.

    Steve

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Blank Area Between Bars (2000)

    Steve,

    Perfect, you da man. I'll run it into the boss now.

Posting Permissions

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