Excel 2007 Chart Question

[bdunk]

I have a chart that, like most charts, has labels and values below the chart in the data table. My data table has four labels on it. I was wondering if it is possible to display the label but hide the actual values for a particular label. For instance, I have a label called "Series 1". These are dollar values. I would like to show the label name (Series 1) but hide all the actual values next to this label. The next label is a percentage. I would like to show this label and its values.

Not sure is this is possible,

Thanks for the help
Brian

 

[RoryA]

You cannot do much formatting with the data table of a chart. If you need this, you would be better off creating a range underneath the chart that links to the data you want displayed (if the chart is embedded in a sheet) or using the camera tool to link a formatted range.