Excel Chart query
Results 1 to 3 of 3

Thread: Excel Chart query
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2017
    Posts
    287
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Chart query

    I have a 'Line with Markers' chart plotting the data range ... 'View Individual Student Profile'!$D$56:$E$68

    I've removed the line, so all I have is thick, black dot markers for each of the 13 data points, however, I'd like the 2rd, 5th, 9th, and 12th dot markers to be red.

    I can't instantly see a way to do this.

    Is there an easy way that I'm not seeing, or at least a work-around ?

    Kind regards,

    Chris

  2. #2
    Board Regular
    Join Date
    Feb 2018
    Location
    Oz
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel Chart query

    G'day p

    When you first click on a marker they all get selected, if you click again on a target marker the remaining markers are deselected and you can change the properties of just that marker. Subsequent clicks will select other individual markers. There does not seem to be a multi-select function. I.e Ctrl + Click does not work.

    Cheers

    shane
    Be warned - I'm an Excel enthusiast, not an expert.

  3. #3
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,662
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Excel Chart query

    Hi Chris

    If this is a one time task then Shane already explained how to.

    If this is some kind of chart that you usually have to do and the colour of the points is not always the same, depending on some logic, then I'd split it in 2 series. This way you can format each set of points in 1 go.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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