Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Display Custom Market & Value

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
How tp display fractions / custom number Diane Excel Worksheet Functions 2 December 22nd 06 09:57 PM
How do I display custom file properties in a cell Glen Perry Excel Discussion (Misc queries) 4 November 20th 06 05:59 PM
Why error message when trying to display custom view? creativeops Excel Discussion (Misc queries) 2 January 9th 06 09:57 PM
Custom Number Display Lee Harris Excel Worksheet Functions 2 December 6th 05 01:19 AM
Why does Custom Format not control Cell Display? Dennis Excel Discussion (Misc queries) 1 June 11th 05 12:28 AM


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