Can I make a chart that is longer than the offered page sizes?

D

Digger

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.
 
S

Shane Devenshire

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a calandar chart 1
How do I make a 2 x axis series bars larger? 1
Chart PageSetup Size Speed VBA 4
xy scatter chart-How can you make the axis equal for a 1H:1V plot 9
How can I show data under a Chart that I inserted in a worksheet? 1
Can a chart reference the local page 3
Can I make a "tab name" the "chart title"? 2
Is there a way in PP to do a custom print page greater than 54" lo 1

Top