Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Data Tables in Charts
Can you highlight/fill individual cells, rows, or columns of a data table
within a chart? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Data Tables in Charts
Hi,
No. Formatting of the chart data table is very limited. If possible use worksheet cells to display a data table. More info here, http://tushar-mehta.com/excel/newsgr...able/index.htm Cheers Andy Reddo wrote: Can you highlight/fill individual cells, rows, or columns of a data table within a chart? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Data Tables in Charts
Hi,
No. Personally, data table are a real problem, for example if you have a lot of data, they're hopeless. You best solution is to place the data in a range below the table and include the range and the range under the chart as the print range. Since you can do just about anything to the data range in the spreadsheet this is a perfect solution. There is a second, less useful approach - whereever the data is you can format it any way you like and then use the Camera tool to snap a picture of the range (with all its formatting) and paste it on the chart. Resize the plot area and put the picture below it. This would be an alternative for example if your chart was on a chart page. The camera picture is linked to the data and is therefore dynamic. You can find the Camera tool by choose View, Toolbars, Customize, Commands tab, Tools category, Camera -- Thanks, Shane Devenshire "Reddo" wrote: Can you highlight/fill individual cells, rows, or columns of a data table within a chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding new data to tables and charts in excel sheets from 97/2003 | Excel Worksheet Functions | |||
Data Items Values In Pivot Tables/Charts | Excel Discussion (Misc queries) | |||
Data Tables in Charts - Totals | Charts and Charting in Excel | |||
Putting data tables with charts | Charts and Charting in Excel | |||
conditional format of data tables in charts | Charts and Charting in Excel |