How do I read values from a line chart?

L

Lynn

I want to draw lines from the y axis over to the data line and down to the x
axis. I also need to show the value on the x axis. Please can someone help?
 
B

B. R.Ramachandran

Hi,

Create an XY-Scatter Plot, rather than a line plot.
Right click on any data point ---> "Format Data Series" ---> "X-Error Bars"
tab ---> select the "Minus" box, check "Percentage" radio button and enter
100 for % ---> repeat this in the "Y-Error Bars" tab ---> then go to "Data
Labels" tab and check "X Value"
With a Line Plot, you can get the Data Labels, and only the Y-Error Bars.
In both plots, you can drag the data labels and place them wherever you want.

Regards,
B. R. Ramachandran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding asymptote equation and how to draw them in excel 0
simple chart 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Make Y-axis values correspond to x- axis value 1
Adding a line to a population bar chart 0
Comparative Scatterplot?? 1
Scatter chart with categories on x-Axis 2
A line chart 3

Top