PC Review


Reply
Thread Tools Rate Thread

Charting Problem

 
 
EE
Guest
Posts: n/a
 
      26th Feb 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting in VBA problem jmacclure Microsoft Excel Programming 1 21st Dec 2005 02:51 PM
Custom charting - Stacked charting with a line Randy Lefferts Microsoft Excel Charting 3 3rd Mar 2005 03:10 AM
Charting Problem =?Utf-8?B?UGV0ZXIgQg==?= Microsoft Excel Charting 1 5th Aug 2004 01:23 PM
Charting problem Paul Microsoft Excel Charting 2 12th Jun 2004 11:49 PM
Re: Charting Problem VBA Jon Peltier Microsoft Excel Programming 0 24th Aug 2003 03:05 PM


Features
 

Advertising
 

Newsgroups
 


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