Hello:
I would like to make a line chart of a single column of numbers with certain ranges of the column a solid line and other ranges a dashed line. Right now I can make a solid line chart of the data and then click on a two data point segment of the line and change this two-point segment to dashed. The problem is I can only do this for one two-point segment at a time which is is cumbersome and time consuming. Anyone know how to do this for more than a two point segment? Thanks.
Sbarnhar
I'm not sure whether I understand your question correctly, but if you want to change the entire line to dashed style double click the line so that the dialog box opens. Change the line style in the dialog box and save.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
As long as the dotted line in not required in the middle of the line you can use this work around
http://www.andypope.info/ngs/ng45.htm
Thank you so much, your work around works great!!
Sbarnhar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks