# Creating an intensity chart

1. ## 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. ## 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.

3. ## 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. ## Re: Creating an intensity chart

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

Can you post example workbook?

5. ## Re: Creating an intensity chart

Ok, here is those intensity values.

6. ## 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

7. ## Re: Creating an intensity chart

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

8. ## 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. ## 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. ## Re: Creating an intensity chart

Thank you again!

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

##### Users Browsing this Thread

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

#### 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