Thread: Vertical lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Enna Enna is offline
external usenet poster
 
Posts: 10
Default Vertical lines

I know I have asked this question before, but I simply cannot make it work. I
have tried coying my data into Peltier's VertizontalLine.zip but still I do
not get the proper result. I can do it with Peltier's data but when I want to
delete the secondary x-axis with my data, the data gets wrong, and if I keep
the secondary axis the line is not in the correct place. I would have liked
to send my file, but I can't see that that is an option, so instead I send
you my data if that is any help. I have this type of data quite often so it
would be a great help if I could make the vertical lines work. Thanks

I use Microsoft Office Professional Edition 2003

Here are my data from Aug. 05 till Aug 06, and I want the vertical lines in
October 05, Jan. 06 and Feb. 06.
01-08-05 84
01-09-05 104
01-10-05 310
01-11-05 249
01-12-05 334
01-01-06 561
01-02-06 1873
01-03-06 975
01-04-06 271
01-05-06 174
01-06-06 205
01-07-06 131
01-08-06 97

Okt. 05
01-10-05 0
01-10-05 1

Jan. 05
01-01-06 0
01-01-06 1


Feb. 05
01-02-06 0
01-02-06 1