Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Can I make a chart that is longer than the offered page sizes?

I am using Excel 2003 to graph data over distances of 10 to 15 thousand feet.
The page sizes offered are so small that changes in the data over this range
are difficult to detect.

Is there a way to make a custom page size that is roughly 12 inches tall
with the potential to be infinately long. This way, all the data wouldn't be
crowded into a limited area, and a person could scroll left or right along
the data interval.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default Can I make a chart that is longer than the offered page sizes?

Hi,

Infinitely long - No! You can customize to page size but it is related to
your printer drivers. You pick a different size page by choosing File, Page
Setup and on the Page sheet picking from Pager size.

You can imbed the chart in a sheet an widen the chart as wide as you want,
then when you print you will have a chart on multiple pages, and then you can
do a little old fashion cutting and pasting.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Digger" wrote:

I am using Excel 2003 to graph data over distances of 10 to 15 thousand feet.
The page sizes offered are so small that changes in the data over this range
are difficult to detect.

Is there a way to make a custom page size that is roughly 12 inches tall
with the potential to be infinately long. This way, all the data wouldn't be
crowded into a limited area, and a person could scroll left or right along
the data interval.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Can I make a chart that is longer than the offered page sizes?

You could embed the chart in a worksheet, and make it however large you
want.

A nicer approach would be to only show part of the data on a normal sized
chart, and let the user scroll through the data. See the first example in
Stephen Bullen's charting examples (FunChrt7) at
http://oaltd.co.uk/Excel/SBXLPage.asp#Charting

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Digger" wrote in message
...
I am using Excel 2003 to graph data over distances of 10 to 15 thousand
feet.
The page sizes offered are so small that changes in the data over this
range
are difficult to detect.

Is there a way to make a custom page size that is roughly 12 inches tall
with the potential to be infinately long. This way, all the data wouldn't
be
crowded into a limited area, and a person could scroll left or right along
the data interval.



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
How to make micro chart sizes? JOHNK Charts and Charting in Excel 1 September 27th 08 05:13 PM
are page sizes defined anywhere? JET Excel Discussion (Misc queries) 0 April 20th 06 06:36 PM
can we make a column width different sizes on the same page? karen Excel Discussion (Misc queries) 2 October 19th 05 10:08 PM
how do I add another page with different cell sizes? Merk Excel Worksheet Functions 1 July 29th 05 09:20 PM
Custom page sizes in Excel Mike Matheny Excel Discussion (Misc queries) 0 April 15th 05 05:15 PM


All times are GMT +1. The time now is 04:16 AM.

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

About Us

"It's about Microsoft Excel"