Automatic Y axis scaling
I hav an application that creates a chart in excel through VB (Create an
excel.application object, and create the chart). It works great, except for my Y axis that displays in percentages. Is there a way for the chart to make the Y axis use money values from the data? Thanks Paul. |
Automatic Y axis scaling
Hi,
Does the Y axis display in percentages because your code is telling it to? What code are you using the set the chart type. The Y axis can display numerical values and the number format can be set to display currency. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Paul van Coller" wrote in message ... I hav an application that creates a chart in excel through VB (Create an excel.application object, and create the chart). It works great, except for my Y axis that displays in percentages. Is there a way for the chart to make the Y axis use money values from the data? Thanks Paul. |
All times are GMT +1. The time now is 09:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com