Forum Discussion

Berghie's avatar
Berghie
Copper Contributor
Apr 12, 2024

Excel Charts has lost so much functionality since Excel 2003. No more value using the latest Excel.

Hi

 

Cannot Copy series data & formatting from one graph to another. The data gets pasted on the wrong axis sometimes and somehow gets formatted for who knows where... In Excel 2003 you can do all the formatting on one popup box, close it and multiple changes get applied. Then copy ALL the previous changes to the next series with Ctrl+Y If you try this now, it only copies the last change made to the next series. All the other formatting must be done one by one.

This wastes hours on large charts with 50+ series.

  • Although some functionalities from Excel 2003 may be less accessible or different in newer versions, you can often use tools like Format Painter, VBA macros, and chart templates to streamline the process. Providing feedback and engaging with the Excel user community can also help highlight areas where improvements are needed.

Resources