+ Reply to Thread
Results 1 to 3 of 3

Grouping in a graph

  1. #1
    Registered User
    Join Date
    08-09-2005
    Posts
    98

    Grouping in a graph

    Help please

    I would like to create a graph where the numbers are grouped in such a way as all numbers between 0 and -1 are shown in one column, all numbers between -1.1 and -2 are shown in the next column, all numbers between -2.1 and 3 are shown in another column etc

    The numbers are shown below

    11/03/09
    -2.5
    -3.8
    -3.9
    -4
    -4.1
    -4.5
    -4.6
    -4.9
    -5.2
    -5.4
    -5.4
    -5.5
    -5.6
    -5.6
    -6.5
    -6.7
    -6.8
    -6.9
    -7.3
    -7.8
    -7.9
    -7.9
    -8.1
    -8.3
    -8.4
    -8.7
    -9
    -9.1
    -9.1
    -9.1

    I know it can be done in Minitab, but I would like to show it in Excel

    I would also like the y axis to show 0 at the bottom and maximum number at the top please

    If someone could help, I would be very grateful.

    Thank you so much
    Lynne
    Last edited by Lynneth; 06-16-2009 at 08:43 AM.

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

    Re: Grouping in a graph

    You need to summarize the data before charting it.

    Either using formula or Pivot table.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-09-2005
    Posts
    98

    Re: Grouping in a graph

    That is exactly what I want

    Thank you so much.

    Lynne

+ Reply to Thread

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