ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2000/2003 Secondary Axis issue (https://www.excelbanter.com/excel-programming/363117-excel-2000-2003-secondary-axis-issue.html)

[email protected]

Excel 2000/2003 Secondary Axis issue
 
Dear All

In Excel 2000, I have an Excel stacked bar chart, with a secondary axis
setup, without area or line, so as to show extra data above the chart
(sales figures above the stacked bar percentages)

Having upgraded to Excel 2003, these extra numbers have disappeared,
although the series is still there, and all setting seem the same.

Apart from the fact of having to change hundreds of charts.....I can't
even manually recreate my chart! - any time I try to have the data
labels above the chart - they vanish.

Any advice on a) how to manually acheive this...and b) would be
brilliant to find a way to automatically convert through code etc(or
stop Excel 2003 messing it up for me!)

Cheers



All times are GMT +1. The time now is 03:20 AM.

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