Display Data Table in chart but don't show plot area

R

RW

I am using Excel 2003. I have created some charts/graphs with data tables,
chart titles, etc. My customer only wants to see the data table and chart
title for each graph. Is there a way to turn off the plot area and change the
size of the chart so that the chart title is close to the data table?
 
B

Bernard Liengme

But the data table merely reflects what is in the cells used to make the
chart!
Why not just display that data in a new format?
Or am I missing something?
best wished
 
R

RW

Well, I need the layout to be exactly the same. The Names of the data sets
have been aliased (which can't be done in the query behind the data for other
reasons) and I also have rolling data that must be calculated.

In the past I have "created" a table format and made individual references
to the cells with data. This is very time consuming since the formula for
each cell must be created individually. The original data is months
vertically down the left which get correctly transposed to months on the X
axis for the chart. Also, blank or null fields must be accounted for in the
cell references so that they do not disply as 0's. The data table for the
chart handles this automatically too.

It would be easiest to just get the chart data table.
 

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

Top