ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Attach Data Table to Bottom of Plot Area (https://www.excelbanter.com/charts-charting-excel/245308-attach-data-table-bottom-plot-area.html)

Mike M.[_2_]

Attach Data Table to Bottom of Plot Area
 
Using Excel 2007, I have a graph with the x-axis showing date values (Jan-09,
Apr-09, etc.). Beneath the plot area, I have a data table with the top row
showing the same date values. A work associate suggested I delete the values
on the x-axis and attach the data table to the bottom of the plot area.

I can't seem to find any info on how to do this.

Any suggestions would be greatly appreciated.

Thanks,
Mike M.

Tushar Mehta

Attach Data Table to Bottom of Plot Area
 
The contents of the data table are defined by Excel with little, if
any, discretion given to the user.

You can simulate the effect of a custom data table. See
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm

On Mon, 12 Oct 2009 18:40:03 -0700, Mike M.
wrote:

Using Excel 2007, I have a graph with the x-axis showing date values (Jan-09,
Apr-09, etc.). Beneath the plot area, I have a data table with the top row
showing the same date values. A work associate suggested I delete the values
on the x-axis and attach the data table to the bottom of the plot area.

I can't seem to find any info on how to do this.

Any suggestions would be greatly appreciated.

Thanks,
Mike M.

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins


All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com