scatter chart

  • Thread starter Thread starter scott23
  • Start date Start date
S

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
 
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
 
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
 
Back
Top