LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jrmruz
 
Posts: n/a
Default How do I create vertical lines in a line chart?

Hi everybody-

I have created a line chart with 20 weeks of data plotted across the X-axis
(each data point corresponds to the response rates to a direct mail
campaign). I now want to plot two vertical lines showing the start of the
campaign (week 4) and the end of the campaign (week 16).

I know I can manually draw a line, but these charts need to be updated on a
regualr basis, and it will take me hours to manually move the lines on the
100 or so charts I produce. So I want to have someway to specify a start
date and end date, and have the charts update automatically.

Thanks,
JM
 
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
How to create combination stacked area and line chart? BarbAug Charts and Charting in Excel 2 May 19th 05 01:18 PM
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 05:12 AM
Lines not visible in an Excel line chart argonaut Charts and Charting in Excel 1 February 18th 05 02:00 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


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