Datatable and Plot area height

[MarkD]

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]

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

 

[Jon Peltier]

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

 

[MarkD]

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

 

[Jon Peltier]

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