ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Field button disappears? (https://www.excelbanter.com/charts-charting-excel/158020-data-field-button-disappears.html)

Rich

Data Field button disappears?
 
On a chart plotting multiple categories that includes a data selection
button, when one selects data in such a way that only 1 item is picked, the
button disappears from the categories axis and a button ends up on the upper
left of the chart that can't be pressed or otherwise has any meaning other
than the name of the single field.

How does one get the selection ability back (button to reappear) without
having to do an 'undo pivot'?

Rich

Data Field button disappears?
 
Anybody have any idea how to corecct this? Having the selectability is nice,
but selecting something causes that ability to disappear making it useless it
seems.


"Rich" wrote:

On a chart plotting multiple categories that includes a data selection
button, when one selects data in such a way that only 1 item is picked, the
button disappears from the categories axis and a button ends up on the upper
left of the chart that can't be pressed or otherwise has any meaning other
than the name of the single field.

How does one get the selection ability back (button to reappear) without
having to do an 'undo pivot'?



All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com