Thread: Help with Charting Data

Hi, I could use someones help.

I have a list of data in 3 columns, one is a list of models of cars, the second and third column are the corresponding price and wheelbase.

i.e.

Honda Accord / 2,800 mm / $32,400
Honda Civic / 2,700 mm / $26,380
.
.
.

I am trying to show price on the Y axis, wheelbase on the X axis and then have the "name" of the model displayed in the corresponding xy location within the chart. I need to plot about 40 models along the wheelbase and price grid.

I tried pivot table but all it gives me is the 'count' but I need the name displayed. Please help.

For each row of data you need to add a series to a scatter chart. Use the name of the car cell for the series name.

Then on chart options select Series Name under Data Labels.

Example attached.

Laura

Little bit of work but it worked perfectly! Thanks!