how to automate min and max on axis based on calculation

G

Guest

While automating some chart making with code, I am trying to automate the
span of time reflected on the x-axis. Auto doesn't work because I need the
beginning to be based on an October of a given year. Similarly I have
requirements for the max.
The appropriate min and max are calculated elsewhere, but I am not sure how
to code it to accept the value from a cell.

Any help would be much appreciated.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Y Axis : Dynamically Hardcode Min/Max Values? 1
secondary category axis reset to min=0 max=0 on save 1
how can I automate chart axes 4
Dynamic Vertical axis in a chart 2
Time Scales on Horizontal Axis - Excel Charts 1
How to create a min-max bar chart in excel 2007 ? 5
xy chart --> x and y axes scales min and max 1
Min and Max Value Changes 6

Top