scatter chart

[scott23]

Sorry for the follow up question, but i dont see my previous question
posted yet and i have an additional unrelated question:

I have data that includes 1 column of labels and a second column of
values.
I want to plot these values in 1 vertical column where the y axis
labels are not just evenly spaced numbers, but are actually the values
that are plotted. In addition i also want to see the labels from the
1st column of data show up to the right of these values.

Thanks if you can help.
scott

 

[Marise Chan]

Data labels may be the answer:
1. Right-click on the chart and select chart options.
2. Go to the Data Labels tab
3. Check the values that you want to display next to the data points.

Hope this helps, Marise

 

[Jon Peltier]

Scott -

I'm not completely clear on what you want. The Y axis labels are in
arbitrary positions based on the values in your worksheet? That sounds
like my Arbitrary Axis example:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Are the other to go right next to the other labels? You can't put
multiple labels on a single data point (which my method above does), but
you could add another dummy series for the other labels.

- Jon