4 ms·

Mark separate areas on the same worksheet as tables, set chart location to be the same worksheet as the tables. If you're bothered by the gridlines those can be

• cm2187 9y ago
  No need to be condescending, I am a heavy excel user, possibly more than you. Tables may be fine in Excel for data but useless for any custom logic, which is what I use the most excel for. I am not aware that tables overflow with a scrollbar like Apple's approach allows. If you need to add more rows to the top table, the bottom table goes off screen. If the top table contains a very wide column, the bottom table needs to have the same column width. These are all inconveniences that apple's approach solves (and wouldn't be very hard to implement in excel while preserving backward compatibility). I don't see how Excel tables solve any of that.
  • ZenoArrow 9y ago
    > "No need to be condescending, I am a heavy excel user, possibly more than you." Believe what you want. > "I am not aware that tables overflow with a scrollbar like Apple's approach allows." If scrollbars matter to you then you can use Power View, which is one of the Power BI features available in Excel. To get a better idea of how it works, take a look at this short video: https://m.youtube.com/watch?v=f6QS13RtrmM https://m.youtube.com/watch?v=f6QS13RtrmM