#1   Report Post  
Larry Excel
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Can Excel calculate area for 3-D surface charts? RAH Charts and Charting in Excel 2 March 20th 05 04:20 AM
Copy multiple charts from Excel to Power Point Genef Charts and Charting in Excel 1 March 2nd 05 02:25 AM
Why will my Excel charts not print in color? cyncha Charts and Charting in Excel 2 December 5th 04 07:56 PM
The x-axis title is truncated in EXCEL charts 2003. Bernard Liengme Charts and Charting in Excel 0 November 26th 04 06:25 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"