ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dragging bar updates tabel (https://www.excelbanter.com/charts-charting-excel/203632-dragging-bar-updates-tabel.html)

MikeT

Dragging bar updates tabel
 
Older versions of excel had a feature that let you click on the end of a bar
and drag it. The new length automatically was updated in the data table. I
have replicated it by writing macros with buttons, where the click identifies
the data element on the chart and the button with a directional arrow
increases or decreases the associated value in the table, but the old touch
the graph and move the bar/data was much easier.


All times are GMT +1. The time now is 10:23 AM.

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