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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display Data Table in chart but don't show plot area
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? |
#2
|
|||
|
|||
Display Data Table in chart but don't show plot area
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "RW" wrote in message ... 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? |
#3
|
|||
|
|||
Display Data Table in chart but don't show plot area
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. "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "RW" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|