+ Reply to Thread
Results 1 to 10 of 10

Creating an intensity chart

  1. #1
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Creating an intensity chart

    Hi

    Is there a way to create an intensity chart in excel?
    I have data which includes hundreds intensity values. I would like to plot them so X-axis is the intensity value and Y-axis is the amount of those values. A histogram will do fine, but if there is a way to draw a curve it that would be great.

    I'm using mac, but I have possibility to use PC if necessary.


    Thank you!

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

    Re: Creating an intensity chart

    Can you create a pivot table from the data and plot that.
    Note that the Line chart would be categorical on the X axis as xyscatters are not available as pivot charts.


    Otherwise you would need to summarize the data using formula and the plot the results.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Creating an intensity chart

    Well, I'm not familiar with pivot tables. I tried to make one, but I had no idea what I supposed to do..

    Is there a simple way to categorize the intensities which are continuous, to small classes and them make a histogram where classes are on teh X-axis and frequency(%) on the Y-axis?

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

    Re: Creating an intensity chart

    Yes you just need to use formula to summarize the data.

    Can you post example workbook?

  5. #5
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Creating an intensity chart

    Ok, here is those intensity values.
    Attached Files Attached Files

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

    Re: Creating an intensity chart

    Here it is using pivot table/chart

    If you right click the Row variable of the pivot table and select Group...
    you can control the start/finish and step values for grouping
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Creating an intensity chart

    Thank you very much. I think I'll manage now by myself.. at least I hope so

  8. #8
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Creating an intensity chart

    Well.. I didn't manage by myself. I don't succeed to create a similar pivot table that Andy made. I tried to follow the creating protocol from ExcelTips, but I just don't get it.

    This is how far I've made it:

    1. I select my data
    2. I'll go to Data->Pivot table report
    3. I create a pivot table
    4. My pivot table is empty. When I drag my data to the data column, there appears only one number. I'm confused.

    Step by step protocol would be nice


    Thanks again!

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

    Re: Creating an intensity chart

    With your empty pivot table you need to

    Drag Data2 field from the PivotTable Field List and drop on the Row Fields area of the PT.
    Now drag the Data2 field from the PivotTable Field List and drop on the Data Items area of the PT

    Change the Row field to be Count of rather than Sum of.
    Right click the Cell with Sum of Data2.
    Field Options
    Summarize by: Count

    Right click Data2 cell in Row area and pick
    Group and show detail
    Group...

    set the start/finish/step values to suit.

  10. #10
    Registered User
    Join Date
    06-25-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Creating an intensity chart

    Thank you again!

    Now even I got it right. The mysteries of excel are about to reveal themselves!

+ 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