B
Bob Barnes
I'm running Access-to-Excel automation for a Calendar Year's Data. If I set
the Data Range to 53 rows, by 2 columns, I can populate up to 53 weeks worth
of Data...365 (366) days = "53 weeks".
As the Chart fills w/ data for a full-year, I need to widen it (and print on
11 by 17 paper) to see all 53 data points.
Is there a way to have the "Data Range" "select" only the number of weeks
that have occurred...IE, If 12 weeks, the "Data range" plots only those 12
weeks...
TIA - Bob
the Data Range to 53 rows, by 2 columns, I can populate up to 53 weeks worth
of Data...365 (366) days = "53 weeks".
As the Chart fills w/ data for a full-year, I need to widen it (and print on
11 by 17 paper) to see all 53 data points.
Is there a way to have the "Data Range" "select" only the number of weeks
that have occurred...IE, If 12 weeks, the "Data range" plots only those 12
weeks...
TIA - Bob