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: 244
Default Line chart with vertical bars

Hi! I have a normal line chart (eg a chart with atwo lines. one showing the
price of pepsi and the other showing the price of Coca cola). On the x-axis I
show the dates. Now on certain dates I want to insert bars into the graph to
highlight to the view that something has happened. The bars shall go from
the top to the bottom of the chart.

I have tried doing that by creating a "time series" for the bars ie showing
a very high value on the dates that I want to highlight and zero otherwise.
this did not work. I also tried adding Highest-Lowest bars to the bars but
they spilled over into the lines. Is there anyone how knows of a good way of
doing this or maybe a site that explains how to do it I would be most
grateful for your help. Thanks!
 
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 add a Vertical Line to a Column or Line Chart with two axes already in use? Alan Charts and Charting in Excel 6 December 13th 06 03:37 AM
Vertical line in a histogram (vertical bar chart) AdamCPTD Excel Discussion (Misc queries) 0 July 13th 06 09:43 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
adding vertical bars to an embedded chart using VBA Wazooli Excel Discussion (Misc queries) 0 November 15th 05 05:47 PM
How to add a vertical line to a Line Chart that aleady has 2 Y axi ISUTUBBS Charts and Charting in Excel 1 October 28th 05 04:20 AM


All times are GMT +1. The time now is 01:06 AM.

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

About Us

"It's about Microsoft Excel"