Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting data labels on xy chart from additional plot area | Charts and Charting in Excel | |||
How do I display a formula calculation in plot area of a chart? | Charts and Charting in Excel | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
How can I display my table in chart area? | Charts and Charting in Excel | |||
Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel |