Chart not displaying correct number format?

**Aland2929** · 10-14-2012, 12:34 PM

My chart is driven by three option buttons: Qty, Cost & Unit Cost. The chart feeder has been conditionally formatted and works correctly but the chart does not display the correct formatting on the data labels? I have attached a sample file.
Thanks in advance

**dilipandey** · 10-14-2012, 12:56 PM

Hi Aland2929,

You need to custom format the data labels the same way you formatted the data source.. see attached:-
TestChart.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**Aland2929** · 10-14-2012, 01:00 PM

Thanks for your response but the formatting is the same for all the options on your workbook? The first option should be comma to zero decimals; the second option - currency no decimals; the third option - currency 2 decimals.

**dilipandey** · 10-14-2012, 01:02 PM

Ok... but did you formatted your data source the same way

I hope not.. you applied the different formatting to your data source i.e., separately and one by one ... so same funda applies here.
Else, you need to reply on macros (VBA).

Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Aland2929** · 10-14-2012, 01:12 PM

Once again, thanks for your response but the problem remains unsolved. I am hoping this is possible without VBA.

**Aland2929** · 10-14-2012, 01:17 PM

The formatting in the chart feeder responds correctly to the option button selections but the data labels in the chart do not change according to the chart feeder? I am sure there is a simple solution to this?

**dilipandey** · 10-14-2012, 01:26 PM

Okay.. I am making myself an interesting party here and will look forward for any option to achieve that. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>