•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Data Bars - Expanding Table
Our take
If you're looking to enhance your spreadsheet experience, automating data bars can significantly streamline your workflow. When expanding a table, it is indeed possible to automatically add data bars that connect new rows, such as linking A3 to B3 and C3 to D3 seamlessly. This feature allows for a more intuitive visual representation of your data as your table grows. Let’s explore how to set this up effectively, ensuring your data remains clear and impactful without manual adjustments each time you expand.
I've been trying to figure this out for some time, is it possible to automatically add data bars when expanding a table?
In my table, A2 is connected to B2, C2 to D2 etc.
Can I automatically get new data bars connecting A3 to B3 and C3 to D3 when expanding the table one row down?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience