Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Datatable and Plot area height

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MarkD - 11 Dec 2003 19:39 GMT
Using Excel 2000

I'm trying to set the height of the datatable, but this
ends up changing the height of the plot area. Is there a
way to change the height of the data table without
changing the height of the plot area?

I need to do this because I have about 10 series that I'm
plotting and in order to see all the rows in the
datatable, I have to expand the plot area to fill half the
screen.

Thanks,
-Mark
Dave Ramage - 12 Dec 2003 14:41 GMT
I don't think the data table can overlap the plot
area...if thats what you are after.

An alternative is to use the camera tool to produce the
data table. First step is to add the camera button to a
buuton bar (if its not there already..):
1) Right-click any existing button bar and select
Customize.
2) Switch to the Commands tab
3) Select Tools from the categories list
4) Drag the camera tool onto a button bar

Now use the tool:
1) Select the data table range on the worksheet
2) Click the camera button
3) Switch to the chart sheet and draw out a box for the
table.
4) The table produced is sizeable and will update when the
source table is changed.

This method works for any worksheet content, not just
tables.

Cheers,
Dave
>-----Original Message-----
>Using Excel 2000
[quoted text clipped - 13 lines]
>
>.
Jon Peltier - 12 Dec 2003 15:41 GMT
Another alternative is to dispense with the inflexible and unwieldy data
table in favor of a table in the cells under the chart.  You can format
this however you want, different formatting for different cells, all
that.  You can include and exclude any data you want, too.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I don't think the data table can overlap the plot
> area...if thats what you are after.
[quoted text clipped - 42 lines]
>>
>>.
MarkD - 15 Dec 2003 17:48 GMT
Hey Jon,

Thanks for the suggestion. I was thinking about that, but
don't see an easy way to associate the data with the
actual lines (I'll be using a line graph). I don't want to
use a legend as that would make things reduntant.

I'll see if your website has any solutions regarding this,
but off-hand, can you think of any?

Thanks,
-Mark

>-----Original Message-----
>Another alternative is to dispense with the inflexible and unwieldy data
[quoted text clipped - 56 lines]
>
>.
Jon Peltier - 15 Dec 2003 18:30 GMT
Mark -

If your lines have distinct colors, you could use the colors for the
text in the relevant rows of the table.  Or you could try the Label Last
Point macro on my site:

 http://www.geocities.com/jonpeltier/Excel/Charts/LabelLastPoint.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> Hey Jon,
>
[quoted text clipped - 87 lines]
>>
>>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.