Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How tp display fractions / custom number | Excel Worksheet Functions | |||
How do I display custom file properties in a cell | Excel Discussion (Misc queries) | |||
Why error message when trying to display custom view? | Excel Discussion (Misc queries) | |||
Custom Number Display | Excel Worksheet Functions | |||
Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) |