Need help making chart using data from two columns? Elementary....

A

Andy_CYXU

Hi, This is prabobally very simple I guess, but I can't
figure out how to get it to work.... I was trying to make
a chart that would use data from two columns.. more less
like that:

One column "A" let's say has names of people who bought
something JACK, JOHN, JEFF etc...

SECOND column "B" has how much they each spent next to
their name so whatever $1, $2, $15 etc...

Now the names will repeat with some other $.... of who
bought something.

So this is what I would like the chart to do...

Check column "A" find all the JACK's and SUM what he
spent from COLUMN "B" so you end up with let's say JACK
name was found 2times and SUM of all he spent from
column "B" was $30 and then make a chart and it would
show who spent how much

EXAMPLE:

COLUMN"A" COLUMN"B"
1 JACK $10
2 JOHN $15
3 JACK $20
4 JEFF $10
5 JOHN $12

So it would count that Jack spent $30, John $27 and Jeff
$10 and graph it...
I tried PivotTables, but they end-up just counting the
words and show JACK=2 JOHN=2 JEFF=1 and I want it to
show rather JACK=$30, JOHN=$27 and JEFF=$10

Thanks in advance
Andy_CYXU
 
D

Debra Dalgleish

You can create a pivot table to summarize the data, and create a chart
from the pivot table:

Add a heading to the top of each column (e.g. Name, Amount)
Select a cell in the list
Choose Data>PivotTable and PivotChart Report
Click Next, select the cells with data, click Next
Click Layout
Drag the Name button to the Row area
Drag the Amount button to the Data area,
where it will become Sum of Amount
Click Next, choose a location for the Pivot Table, click Finish
Then, click the Chart Wizard button, to create a PivotChart
from the PivotTable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top