Hi,

Over the years I have created many excel charts. Sometimes I will just
select the data range, and then click the chart button; sometimes I just
start with the chart button.

Some of my charts have what I call AUTO HIGHLIGHTING. When I click a blank
area in the chart (line charts, embedded in the sheet), the X & Y data ranges
are automatically highlighted in blue and magenta. If I click on one
highlighted column and drag to expand the range, the other automatically
follows.

I have many other charts, created the same way, that do not exhibit this
behavior. On these, I can only get the data to highlight if I click on the
actual DATA SERIES LINE in the chart. However, if I drag to expand the
selection, the other highlighted column(s) do not follow.

Does anyone know how to make these charts follow the AUTO HIGHLIGHTING as
mentioned above?

I have searched but cannot figure out the differences.

Thanks much,

Mark