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


 
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
I just want lines to appear on my worksheet vertical and horizont Scout Excel Worksheet Functions 5 December 2nd 06 01:24 AM
Add vertical lines to a line chart (already has 2 Y axis) PaulW Charts and Charting in Excel 3 November 21st 06 04:19 PM
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting in Excel 3 March 3rd 06 04:14 AM
Columns showing up as thin vertical lines Lee Excel Discussion (Misc queries) 1 October 26th 05 03:16 PM
How do I create vertical lines in a line chart? jrmruz Charts and Charting in Excel 2 June 1st 05 02:41 PM


All times are GMT +1. The time now is 10:58 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"