# Thread: Scatter Chart ? (Excel 2002)

1. ## Scatter Chart ? (Excel 2002)

Hi

I am trying to create a scatter chart to sum values, based on text in an adjacent cell.

Many Thanks

2. ## Re: Scatter Chart ? (Excel 2002)

A scatter chart doesn't make much sense here - a chatter chart is used if the x axis values are numeric.

In fact, the whole chart doesn't make sense to me. The way the points are plotted suggests a non-existent relation between the two series. What do you want to happen if there are more "A"s than "B"s?

3. ## Re: Scatter Chart ? (Excel 2002)

Hi Hans

This is inherited but the person who created it sorted by ABC then applied the data just selecting the As Bs Cs and Ds, It doesn't matter if there are more As or Bs,
Also it doesn't have to be a scatter chart, I just want a graph that shows the values of all the A's B's etc. The A's B's etc will vary every month.

Thanks

4. ## Re: Scatter Chart ? (Excel 2002)

Hi Braddy could you use the sumif function similar to this:

=SUMIF(I2:I100,"A",K2:K100)
=SUMIF(I2:I100,"B",K2:K100)
=SUMIF(I2:I100,"C",K2:K100)
=SUMIF(I2:I100,"D",K2:K100)

Place them in adjacent cells and use a bar chart to show the sum of NIV.

5. ## Re: Scatter Chart ? (Excel 2002)

You could just use a pivot chart, as in the attached demo. Note that pivot charts tend to lose any manual formatting when you refresh them so, if that's an issue, create a standard chart based on the pivot table rather than an actual pivot chart.

6. ## Re: Scatter Chart ? (Excel 2002)

Hi Rory

Sorry I did not get back to you, I was gently reminded by Hans of my miscarriage of protocol.

Thanks for your suggestion, but it appears you cannot create a scatter chart from a pivot table.

7. ## Re: Scatter Chart ? (Excel 2002)

That is true but then, as already suggested, a scatter chart doesn't appear to make sense for what you are doing! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

8. ## Re: Scatter Chart ? (Excel 2002)

HI Rory

Unfortunatley a scatter chart is the the last chart I would select for this, however the accountant insists on this is what he wants.

With Steves help yesterday I think I can appease him.