Results 1 to 3 of 3

Multiple Criteria Line Graph/scatter plot

Threaded View

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

    Re: Multiple Criteria Line Graph/scatter plot

    Use a pivot table to build your data table.
    You can even create the Line chart automatically.

    I have changed some of your data points so you can see other months and years.

    The column field is grouped by Year and Month.

    For more information on pivot tables see
    http://www.contextures.com/tiptech.html#P
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

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

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