1

In Excel 2010, I want to automatically highlight the peak point on this graph (the 3rd one from left to right), so it'll become red.

enter image description here

What should I do?

Improve this question
3
  • 1
    Welcome to Superuser. What have you tried and/or researched on your own?
    – CharlieRB
    Nov 6, 2013 at 17:23
  • 1
    Do you want to highlight the overall maximum or any local peak?
    – Excellll
    Nov 6, 2013 at 18:42
  • It's possible to do this with a scatter chart using a named array formula and a trick with the y-axis minimum. I don't have time to write up a proper answer, but see this link for an example sheet.
    – chuff
    Nov 6, 2013 at 21:06

1 Answer 1

Reset to default
2

You'll need to create a second column of data with formulas that only put a value in the cell with the maximum value, then add that column to the data and format it differently so it stands out.

This link has more information on how to do this. (From www.chandoo.org post titled "Highlighting Data Points in Scatter and Line Charts")

Here are the highlights:

  • Create a new column next to your data

Let's assume you have data in columns A and B with headers in row 1. In cell C2 enter the formula:

=if(B2=max(B:B),B2,NA())

Then copy it down for all your data

  • Add the data in column C to your chart

Title it "Max"

  • Format the new Data Series

Select a bigger marker size and the color you want the marker to be.

Improve this answer
2
  • That has problems associated with it. You need to create a new series (IIRC you can't hide it afterwards) and you need to manually format the series' value. At any rate, can you please post the relevant parts of the method, as to avoid link rot?
    – Doktoro Reichard
    Nov 6, 2013 at 19:33
  • It is possible to hide the extra column of data with a change to the chart properties. Also, once the formulas are entered there is should be no other interaction needed.
    – guitarthrower
    Nov 6, 2013 at 23:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .