Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart auto data highlighting anomaly....
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart auto data highlighting anomaly....
Hi,
I figured it out. If the data in columns is not in a certain order, then the AUTO Highlight & Drag to select thingies do not work. Data must be X axis data -- Y Axis data. So for example, my X axis data must be in Column A and y axis data in column B. If they are reversed, it does not do the auto highlight and drag for multiple columns. Thanks very much self, Mark "Mrpush" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Highlighting!! | Excel Discussion (Misc queries) | |||
auto highlighting of cells when clicked on | Excel Discussion (Misc queries) | |||
Merging Cells that contain data anomaly | Excel Discussion (Misc queries) | |||
Scatter Chart Data Point Highlighting | Charts and Charting in Excel | |||
Anomaly with Chart Labels | Charts and Charting in Excel |