+ Reply to Thread
Results 1 to 4 of 4

Charting 20 series

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    12

    Charting 20 series

    I've been asked to produce pivot line charts showing a value per month over 12 months.

    There will be 20 (or more) series and the values do not vary that much.

    The resulting charts are almost illegible, even after using different line styles and colours.

    Replacing the chart with a conditionally formatted pivot table may be a solution, but are there any other options?

    Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Charting 20 series

    Maybe use Sparklines. See: https://support.microsoft.com/en-us/...b-5c60e620f5ca
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-02-2017
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    12

    Re: Charting 20 series

    Thanks for your reply

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Charting 20 series

    You're welcome. Thanks for the rep.

+ 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. [SOLVED] Charting a series of values
    By skaze in forum Excel General
    Replies: 2
    Last Post: 05-22-2012, 01:44 PM
  2. Charting series in excel
    By ski_jr23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2012, 09:41 AM
  3. Charting - Variable Series
    By watchouse in forum Excel General
    Replies: 6
    Last Post: 09-23-2010, 06:38 AM
  4. [SOLVED] Time-Series Charting
    By asaylor in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2006, 11:15 AM
  5. Charting only non-zero series
    By travis in forum Excel General
    Replies: 2
    Last Post: 12-15-2005, 03:55 PM
  6. Charting Multiple Series?
    By Dan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-29-2005, 03:06 PM
  7. [SOLVED] charting series
    By pj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2005, 11:06 AM
  8. Charting differing series
    By tmi!tmi! in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-21-2005, 02:49 PM

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