+ Reply to Thread
Results 1 to 11 of 11

How to create single marker on the line chart?

  1. #1
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    How to create single marker on the line chart?

    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?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to create single marker on the line chart?

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

    Post example workbook of you current chart if you need more help.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create single marker on the line chart?

    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.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to create single marker on the line chart?

    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.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create single marker on the line chart?

    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
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to create single marker on the line chart?

    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.

  7. #7
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create single marker on the line chart?

    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.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to create single marker on the line chart?

    Here is more detail of custom markers.

    Whether you use my suggestions is up to you.

  9. #9
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create single marker on the line chart?

    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
    Last edited by nelsonys; 07-27-2009 at 10:46 PM.

  10. #10
    Registered User
    Join Date
    07-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How to create single marker on the line chart?

    Here's a pic for a clear view
    Attached Images Attached Images

  11. #11
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to create single marker on the line chart?

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1