LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
Posts: 128
Default Connecting missing points with a dotted line

Hi,

I have a question about charts. I have a solid line connecting each of my
points in a time-series (days in a month). However, I am missing several
points. For example, lets say Tuesday-Friday of the first week is missing. I
want to connect Monday to Saturday using a dotted line. Right now the cells
for Tuesday-Friday are blank, so it does not draw anything. How can I do this
dotted line most efficiently? Thank you very much!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing data points causes my line graph not to connect liebw Charts and Charting in Excel 8 November 24th 08 10:15 PM
How to Draw a chart line connecting 2 points in the middle of the series KathyC Charts and Charting in Excel 3 November 28th 06 12:30 AM
how to put connecting line between data points on scatter chart? Marc Charts and Charting in Excel 2 November 24th 06 05:51 PM
Right column missing; vertical dotted line is moving left NorthernLights New Users to Excel 1 June 11th 06 06:33 AM
Connecting Points In An XY-Scatter Plot Graph Adam WK Charts and Charting in Excel 2 April 9th 06 07:05 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"