Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Charting Problem

Hi

Maybe this is a simple chart example but I am not able to figure it
out.

I have some data in the format below.


Date 1 Value
1 Jan 10
2 Jan 20
3 Jan 40
4 Jan 30
5 Jan 50

and so on (around 1000 entries)

Now I have some events that happen at certain values. Like at 30 there
is a positive event that has a value +10%. Lets say at 40 value, I
have a negative event has a value -10%.

I store this information in two columns. I can also concatenate it if
needed.

I want the Text "P 10%" along with a Marker at the value 30 and text
"N -10%" along with a marker at the 40 value. On the same chart.

How do I accomplish this. I have tried Line charts with XY scatter in
a series but I seem to be doing something wrong.

I hope I communicated this clear.

Thanks for all the help.

Prasad
Reply
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
Problem with Excel Charting ... Please Help zoddiax Charts and Charting in Excel 1 October 11th 07 07:58 PM
CSV Charting Problem Quicksilver2002 Charts and Charting in Excel 1 June 6th 06 06:58 PM
Charting in VBA problem jmacclure Excel Programming 1 December 21st 05 02:51 PM
Charting Problem Bill[_30_] Excel Programming 0 September 23rd 05 09:57 PM
Charting Problem VBA Jon Peltier[_3_] Excel Programming 0 August 24th 03 03:05 PM


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