View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default how to enter text inside the bars on a bar chart in Excel?

Do the following:

1. Right-click the chart, and click Chart Options
2. Click the Chart Options dialog box, click the Data Labels tab.
3. Under Label Contains, select the Series name and Category name checkboxes.
If required, select the Legend Key to display the legend color associated to
that Data series value.
4. Click OK
The chart displays the Series name and the Values names at each data poins
in the line - Which ever chart type you select.
5. Click on the series name in the chart, a rectangle box displays.
6. Enter text inside the box. The entered text is only for display purpose.
These data series are not stored in the excel sheet. This is done to give
more meaning to the graphics for better understanding.

Note: If you change to a different chart type, you may loose the entered
text, and then you have follow step 5 to step 6 again.

Challa Prabhu

Challa Prabhu