Hello all,
I have about 40 charts where I need to fix Y-Axis to reflect same range (0-500 for example) and fix certain other formatting on X-axis.
I format one chart to suit my requirements and then using paste special format feature in Excel 2016 to fix chart number 2, number 3, ... up to chart number 40.
When I select multiple charts at once, the paste special format option is not available. (meaning paste special format function works only when one chart is selected)
I was wondering if this manual process could be more efficient as it is a tedious and time consuming process.
Any pointers in this regard will be greatly appreciated.
TIA
Sam
Bookmarks