Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Excel Charting ... Please Help | Charts and Charting in Excel | |||
CSV Charting Problem | Charts and Charting in Excel | |||
Charting in VBA problem | Excel Programming | |||
Charting Problem | Excel Programming | |||
Charting Problem VBA | Excel Programming |