Hi , i created a bar chart in which some values are displayed to right side of the bar and some on the bar. now i wana see all values on right on the bar please can any one suggest me the way to do it vandana

Hi , i created a bar chart in which some values are displayed to right side of the bar and some on the bar. now i wana see all values on right on the bar please can any one suggest me the way to do it vandana

Hi, Could you please provide a screenshot? CheersPlease Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

hi, pls find the below screenshot vandana

Please read the following thread. It might help: http://technet.microsoft.com/en-us/library/dd220469.aspx Please share the results. CheersPlease Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Hi, If you select the series data label and open the property pane, you can set the Position. But mostly this will not work as you think. By default if there is a space at available at the end( left side in case of bar chart), it will display it as you want.But, if there is no space this gets complicated. There are some workarounds you can try 1. Try Increasing chart width 2. Change CustomPosition in Chart Area Property. Open the property pane and click in the chart somewhere near the bar but not on the bar or grid line. Set this property value to 80 or so. 3. Try seeting some smaller font values for lables. Hope this helps.- Chintak (My Blog)

Hi, If you select the series data label and open the property pane, you can set the Position. But mostly this will not work as you think. By default if there is a space at available at the end( left side in case of bar chart), it will display it as you want.But, if there is no space this gets complicated. There are some workarounds you can try 1. Try Increasing chart width 2. Change CustomPosition in Chart Area Property. Open the property pane and click in the chart somewhere near the bar but not on the bar or grid line. Set this property value to 80 or so. 3. Try seeting some smaller font values for lables. Hope this helps.- Chintak (My Blog)

Hi, actually i want the data present in red box should be out of bar(same as other values)vandana

Hi, If you select the series data label and open the property pane, you can set the Position. But mostly this will not work as you think. By default if there is a space at available at the end( left side in case of bar chart), it will display it as you want.But, if there is no space this gets complicated. There are some workarounds you can try 1. Try Increasing chart width 2. Change CustomPosition in Chart Area Property. Open the property pane and click in the chart somewhere near the bar but not on the bar or grid line. Set this property value to 80 or so. 3. Try seeting some smaller font values for lables. Hope this helps.- Chintak (My Blog)

Hi Chintak, thanks for the reply it works but i want it to be changed dynamicallyvandana

Normally the position of chart series labels is set to Auto. However you can change the position. Did you follow the link I provided? It described very clear how you can change the position of the labels in any type of charts. However, you can change the label positions by clicking on your bar chart, then in Properties pane, in General section, expand custom attributes and in BarLabelStyle select Centre, Left or Outside as you want. Cheers Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Hi Vandana, When the bar label style is set to Outside, the labels will be placed outside of the bar, as long as it fits in the chart area. If the label cannot be placed outside of the bar but inside of the chart area, the label is placed inside the bar at the position closest to the end of the bar. This is by design.So in your scenario, Chintaks suggestion is exactly right. I am afraid you need to set it manually. Thank you for your understanding. Regards, Charlie Liao

Hi Vandana, When the bar label style is set to Outside, the labels will be placed outside of the bar, as long as it fits in the chart area. If the label cannot be placed outside of the bar but inside of the chart area, the label is placed inside the bar at the position closest to the end of the bar. This is by design.So in your scenario, Chintaks suggestion is exactly right. I am afraid you need to set it manually. Thank you for your understanding. Regards, Charlie Liao

Hi Vandana, When the bar label style is set to Outside, the labels will be placed outside of the bar, as long as it fits in the chart area. If the label cannot be placed outside of the bar but inside of the chart area, the label is placed inside the bar at the position closest to the end of the bar. This is by design.So in your scenario, Chintaks suggestion is exactly right. I am afraid you need to set it manually. Thank you for your understanding. Regards, Charlie Liao