LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 77
Default Duplicate Dates Problem

Hello,

Using Excel 2007.

I have three Columns of data, similar to this:
Wish to have the dates as the X axis, and show the next two Columns on
the same plot.

21-Apr 143 21
26-Apr 147 93
3-May 144 91

13-May 135 128
13 May 128 81

17-May 143 93
17 May 137 86

22-May 127 89
22-May 123 83

I have the first, the Date column, formatted as: Date / 14 Mar

I was hoping to graph this data, and have a line connecting "all" the
points (of each column's data).
For the second Column, I do have lines connecting the data with the
unique dates of 21 Apr thru 3 May
For some reason, this was not done for the third Column, with the same
dates.

a. Any idea why this might be ?

b. For all the data where there are two of the same dates, there are no
lines for any of the data for either column 2 or column 3.

The data points are plotted, the Trend-Line shows, but no connecting
line between the data points.

Is there any way to "connect-the-dots," or having the same duplicate
Dates really precludes this ?

Funny, but a long time ago, I did similar data, and I am almost sure
that Excel did plot all the data with no problems; similar dates or not.

Is there some way to do it ?

Much thanks,
Bob
 
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
Duplicate Dates Kumar Excel Discussion (Misc queries) 1 April 15th 09 07:32 AM
duplicate dates db Excel Worksheet Functions 2 September 4th 08 03:33 PM
subtotal by week with duplicate dates? Beth Excel Discussion (Misc queries) 2 April 5th 08 03:37 AM
Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets Dan Excel Discussion (Misc queries) 2 February 23rd 06 11:46 PM
I need to exclude duplicate patient names for dates of service is. Shannon Excel Discussion (Misc queries) 2 April 11th 05 02:53 AM


All times are GMT +1. The time now is 10:05 PM.

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"