Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Charts
I'm trying to build an Excel chart that will span 15 to 18 months of "daily"
data. I would like to be able to print the chart as a banner. I need to be able to see the entire period looking for trends, etc. I can only get Excel Charts to print to one page, which of course compacts all the data to unreadable size. If a create individual charts by month, I end up with different scales for each month as volumes can fluctuate significantly between months. And, if I can figure out how to get past the scale fluctuations, I'll end up creating and printing a significant number of charts as I'm researching/analyzing across multiple products produced during the 18 month span. Does anyone have any ideas as to a solution for this? |
#2
|
|||
|
|||
To print the chart across multiple pages, you can try Tushar Mehta's
suggestion in the following thread: http://groups.google.ca/group/micros...4b0f6d3?hl=en& Or, to print all variations of your charts with the same scale, double-click the value axis. On the Scale tab, remove the check marks for Auto Min and Auto Max, and enter your own settings. Larry Excel wrote: I'm trying to build an Excel chart that will span 15 to 18 months of "daily" data. I would like to be able to print the chart as a banner. I need to be able to see the entire period looking for trends, etc. I can only get Excel Charts to print to one page, which of course compacts all the data to unreadable size. If a create individual charts by month, I end up with different scales for each month as volumes can fluctuate significantly between months. And, if I can figure out how to get past the scale fluctuations, I'll end up creating and printing a significant number of charts as I'm researching/analyzing across multiple products produced during the 18 month span. Does anyone have any ideas as to a solution for this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Can Excel calculate area for 3-D surface charts? | Charts and Charting in Excel | |||
Copy multiple charts from Excel to Power Point | Charts and Charting in Excel | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |