A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

presenting lots of data in a chart & table



 
 
Thread Tools Display Modes
  #1  
Old April 28th 05, 05:07 PM
tee
external usenet poster
 
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.
Ads
  #2  
Old April 30th 05, 07:55 AM
John Mansfield
external usenet poster
 
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  
Old April 30th 05, 11:44 AM
Tushar Mehta
external usenet poster
 
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.
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 03:35 PM
missing data from table kg1953 Excel Discussion (Misc queries) 0 February 2nd 05 05: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 04:30 AM


All times are GMT +1. The time now is 06:26 PM.


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