Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Dec 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    order of data table items in a a chart (2000)

    I have ordered the data series in the chart to display the way that i want. Now I would like to order the data table items so that they are easier to understand. I have attached a file example.

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

    Re: order of data table items in a a chart (2000)

    Welcome to Woody's Lounge!

    How would you like to order the data table items? You can't tell Excel "So that they are easier to understand", so you'll have to be specific.

  3. #3
    New Lounger
    Join Date
    Dec 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: order of data table items in a a chart (2000)

    I would like to have the "Switching %", "Scheduled Switching" and "Net Daily Mhrs" next to on another at the bottom of the data table.

  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: order of data table items in a a chart (2000)

    Select any series on the chart and dbl-click it.
    then select the 'series order" tab
    Select the series to move
    press <moveup> to move them to the bottom of the table

    Steve

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

    Re: order of data table items in a a chart (2000)

    As far as I know, that is not possible since Switching % and Scheduled Switching are column chart series and Net Daily Mhrs is a line chart series. By changing the series order you can put them together, but it'll be in the middle of the data table.
    Instead of using a data table, you could put a table below the chart with the desired sort order.

  6. #6
    New Lounger
    Join Date
    Dec 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: order of data table items in a a chart (2000)

    Thank you for your assistance. This was just what I needed to get me unstuck. I have about 30 charts to do and I wanted to get the format right before modifying the rest of them. I changed "Daily Mhrs" to a column and put "none" on the formatting so that it wouldn't show on the chart.

Posting Permissions

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