+ Reply to Thread
Results 1 to 2 of 2

Sequence of items in data table

  1. #1
    Registered User
    Join Date
    09-11-2015
    Location
    Belgium
    MS-Off Ver
    Microsoft Office 2013
    Posts
    1

    Sequence of items in data table

    I have the strangest problem with arranging items in a Data Table under a chart.

    Normally I could shift the "Legend Entries" via Select Data... when right-clicking the graph and these changes in sequence are then reflected in the Data Table under the graph. For one of these series however, this does not work. The series stays in the last place of the "Data Table" irrespective of its position in the Select Data window.

    It looks like this is another type of series. I have attached a screenshot. How can I solve this?

    Thanks!

    S2015-09-11 15_14_51-.png

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

    Re: Sequence of items in data table

    I can't see the picture but position of legend entries is also dependent upon chart type and axis used. So if your chart has combination of chart types and or use of primary and secondary axis then the order will be restricted.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Show items with no data on pivot table.
    By brent_milne in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-21-2023, 09:49 AM
  2. Items Out Of Sequence.
    By Feastie in forum Excel General
    Replies: 4
    Last Post: 01-21-2014, 08:09 AM
  3. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  4. Distributing data across items in a pivot table
    By awg292 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2012, 06:36 PM
  5. Replies: 1
    Last Post: 04-12-2010, 04:29 PM
  6. Replies: 2
    Last Post: 10-07-2005, 03:05 PM
  7. [SOLVED] Pivot Table - show items with no data
    By HJM in forum Excel General
    Replies: 3
    Last Post: 06-22-2005, 08:05 AM

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