How to create single marker on the line chart?

nelsonys · #1 07-23-2009, 11:32 PM

I wish to randomly place a marker on the line chart at my desired point.
Is there a way to make it without having every points being labeled?

What is the code for this?

Andy Pope · #2 07-24-2009, 04:52 AM

You could add another series with only the required points being plotted.

Post example workbook of you current chart if you need more help.

nelsonys · #3 07-24-2009, 12:22 PM

Erm, my problem is I hope to create something like placing a single marker on my desired point. It's just like having a simulation, and you place a marker on a random point of the simulated waveform to get the value of it instead of of having every points of the waveform being labelled like what Excel did.

Andy Pope · #4 07-25-2009, 06:58 AM

You are using jargon to describe your problem so I am none the wiser.
What do you mean by simulation or waveform?

If you had posted example as requested maybe those terms would have been more easily understood.

Is this something you can work with? The scroll bar allows you to label any one of the charted points.

nelsonys · #5 07-26-2009, 08:42 PM

I have a line chart comprises of 2500 data points, so I don't think line chart with markers at each data values could be my solution.

What I really need is I am able to generate my own marker, and put on one of the data values

Andy Pope · #6 07-27-2009, 03:51 AM

So how does my example not meet with your description?

You can use autoshapes or pictures to create custom markers.
Copy the shape, select the series, select the specific data point and Paste.

nelsonys · #7 07-27-2009, 05:23 AM

Sir, correct me if I'm wrong.

So I am going to use custom drawing/autoshapes to create my desired marker. Then I use the way you label line chart to show the data values of my desired point then I placed my custom marker on it.

Thanks a lot.

Andy Pope · #8 07-27-2009, 05:34 AM

Here is more detail of custom markers.

Whether you use my suggestions is up to you.

nelsonys · #9 07-27-2009, 09:59 PM

Hi Sir,

I found that the X Value and Y Value under the tab of Data Labels of Chart Option are marked with Green Square instead of tick in your example.
But I could not do so if generate a chart using my own excel.

I'm using Excel 2003

nelsonys · #10 07-27-2009, 10:47 PM

Here's a pic for a clear view

Andy Pope · #11 07-28-2009, 08:50 AM

That would suggest that you applied a data label to a single data point.

The green box denotes mixed choices. Some points have a data label others don't.

Welcome to the Excel Forum

Forum Statistics