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 |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com