PC Review


Reply
Thread Tools Rate Thread

How do I read values from a line chart?

 
 
=?Utf-8?B?THlubg==?=
Guest
Posts: n/a
 
      8th Oct 2005
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?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Qi4gUi5SYW1hY2hhbmRyYW4=?=
Guest
Posts: n/a
 
      9th Oct 2005
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

"Lynn" wrote:

> 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?

 
Reply With Quote
 
=?Utf-8?B?THlubg==?=
Guest
Posts: n/a
 
      9th Oct 2005
Many thanks. Thats great
 
Reply With Quote
 
Tushar Mehta
Guest
Posts: n/a
 
      9th Oct 2005
For an interactive solution see
Interactive Chart
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <52615634-C3E0-4783-AB81-(E-Mail Removed)>,
(E-Mail Removed) says...
> 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?
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Min and Max values in Line chart... =?Utf-8?B?TldP?= Microsoft Excel Charting 0 25th Oct 2007 11:06 PM
Line chart zero values JC Microsoft Excel Charting 4 9th Jan 2006 12:57 AM
line chart with NA() values grime Microsoft Excel Charting 3 19th Oct 2005 01:56 PM
Excel 97 - Chart Line - Gap for zero values Michael Goodwin Microsoft Excel Discussion 1 24th Aug 2004 12:37 AM
Line chart zero values Walshy Microsoft Excel Charting 4 16th Jun 2004 04:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:15 PM.