Excel: Scatter Plot with Text on X-axis possible??

[tsoccer63]

I have a ton of data with some text that i want in a scatter plot but it wont put the names on the x-axis for me. Heres an example


BP EP EP BP EP

200 400 350 250 410

The data is organized like that...I want EP and BP on the x axis and all the values that coorespond to it on the Y.

I cannot move the data around to sort it.

 

[SkipVought]

Hi,

Don't understand what you are looking for with a scatter chart.

Do you want the EPs & BPs summed? Then try this...
[tt]
Desig Val
BP 200
EP 400
EP 350
BP 250
EP 410
[/tt]
Then use a PivotTable to SUM by Disig.

Skip,

_[red][/red]

 

[tsoccer63]

Yeh I original had a pivot chart with averages but was asked by someone higher up to show ALL the data points. They kinda want to be able to visualize the range, stdev, average, and number of data points all at once making a scatter plot with all the points ideal. Its gunna end up looking like 2 vertical lines of points (or 3 because im trying to do this with other text values too).

I guess my only choice is to convert EP and BP to number values and then insert a text box that says "EP = 1" "BP=2" so people understand the graph.