| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
"Data Range" - "Source Data"
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
