Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic scaling of charts | Charts and Charting in Excel | |||
Suppress X Axis Scaling | Charts and Charting in Excel | |||
X-Axis scaling on graph | Charts and Charting in Excel | |||
Varying axis scaling | Charts and Charting in Excel | |||
Auto Scaling of Y-axis | Charts and Charting in Excel |