Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Sheet/Axes
This seems like and probably is a trivial question, but I can't seem to
get it right. I've browsed through this group and found seemingly many solutions that apply to chart objects, but not with a seperate chart sheet im working with. I am referencing the chart sheet via (Excel.Application).Charts(1) like: xlApp.Charts(1).Select I am trying to find a simple way to read the min/max scale of the Y axis, and if they are 0 to 1, change to 0 to 1.2. I've tried many variations but can't seem to find one that actually works -- I also recorded a macro to set this and it wouldnt seem to work either. Can anyone provide a quick sample of what might be used to retrieve and/or set the min/max scale values on a seperate chart sheet? TIA Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having two X-axes on same chart | Excel Discussion (Misc queries) | |||
Is it possible to add more than 2 x-axes to a chart? | Excel Programming | |||
Two-Column, Two Axes Chart | Charts and Charting in Excel | |||
XY-Chart with 4 axes | Charts and Charting in Excel | |||
CHART AxES TITLE | Excel Discussion (Misc queries) |