Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 05, 05:07 PM
tee
 
Posts: n/a
Default presenting lots of data in a chart & table

i update weekly sales information for our retail stores in an Excel table. I
also use this data to create a chart (presented below the table). This
information used to fit nicely on a page, but as the weeks progress, the
table gets longer and longer and the printed page is no longer readable.

Does anyone have suggestions about how I can retain the same information in
the table and make it readable at the same time as keeping the chart
presented below? I've used pivot tables / charts, but I'm not sure if that's
my only option.

  #2   Report Post  
Old April 30th 05, 07:55 AM
John Mansfield
 
Posts: n/a
Default

tee,

I'm probably missing something here so possibly you can post back to explain
further. Are you allow to use multiple pages in your presentation? If so is
it as simple as setting up another page as your data starts to run through
the first printed range?

----
Regards,
John Mansfield
http://www.pdbook.com


"tee" wrote:

i update weekly sales information for our retail stores in an Excel table. I
also use this data to create a chart (presented below the table). This
information used to fit nicely on a page, but as the weeks progress, the
table gets longer and longer and the printed page is no longer readable.

Does anyone have suggestions about how I can retain the same information in
the table and make it readable at the same time as keeping the chart
presented below? I've used pivot tables / charts, but I'm not sure if that's
my only option.

  #3   Report Post  
Old April 30th 05, 11:44 AM
Tushar Mehta
 
Posts: n/a
Default

It would appear that the laws of physics would allow only two
alternatives:

You can either use more pages to print the same information or trunacte
the information (print only the last so many rows for example) so that
it fits on one page.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
i update weekly sales information for our retail stores in an Excel table. I
also use this data to create a chart (presented below the table). This
information used to fit nicely on a page, but as the weeks progress, the
table gets longer and longer and the printed page is no longer readable.

Does anyone have suggestions about how I can retain the same information in
the table and make it readable at the same time as keeping the chart
presented below? I've used pivot tables / charts, but I'm not sure if that's
my only option.



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
insert data into chart Sybil227 Charts and Charting in Excel 2 April 12th 05 02:29 PM
pivot table YingRui Oliviero Excel Discussion (Misc queries) 1 April 12th 05 12:57 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM
missing data from table kg1953 Excel Discussion (Misc queries) 0 February 2nd 05 04:59 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 09:28 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017