I have a bar chart for a data range of cells with %values in Excel 2010 that I want to format the data labels in the chart to only display the data labels for the cells which have text values versus the cells with %values. I have not been able to get any of the existing number formats (e.g., ;;;@)or create a custom number format to do this. Any ideas?
Need Help Formatting Chart Data Labels
- Thread starter Dan
- Start date
Montrey
Member
First,Right click one of the bars in the bar graph and for the data label type choose category name.
Second set up another column with an if statement that references the first cell in the list of your category x labels. Example. =IF(ISNUMBER(F6),"",F6)
Third. Drag this formula down until the last category x label.
Fourth. Go to your chart source and change your category x label to the new list you just made with the if statement.
Second set up another column with an if statement that references the first cell in the list of your category x labels. Example. =IF(ISNUMBER(F6),"",F6)
Third. Drag this formula down until the last category x label.
Fourth. Go to your chart source and change your category x label to the new list you just made with the if statement.
NARAYANK991
Excel Ninja
Hi Dan ,
I have understood your requirement a little differently ; I assume you have a range , let us say one column , of text cells , and another column of percentage values.
You have plotted the column of percentage values , and have displayed the data labels , which are obviously the percentage values.
Now , you wish to display the values only where the associated column of text cells has text in them , and do not wish to display data labels against those percentage values which have no text in the associated cell.
On the lines of what Montrey has posted , set up a helper column , say in column C , where you have the formula :
=IF(A2<>"",A2&" - "&B2*100&" %","")
copied down.
Column A contains either blank cells or cells with text data in them ; column B contains the percentage values.
After the data labels are displayed , click on each one in turn , and in the formula bar , select the respective cell from column C.
Narayan
I have understood your requirement a little differently ; I assume you have a range , let us say one column , of text cells , and another column of percentage values.
You have plotted the column of percentage values , and have displayed the data labels , which are obviously the percentage values.
Now , you wish to display the values only where the associated column of text cells has text in them , and do not wish to display data labels against those percentage values which have no text in the associated cell.
On the lines of what Montrey has posted , set up a helper column , say in column C , where you have the formula :
=IF(A2<>"",A2&" - "&B2*100&" %","")
copied down.
Column A contains either blank cells or cells with text data in them ; column B contains the percentage values.
After the data labels are displayed , click on each one in turn , and in the formula bar , select the respective cell from column C.
Narayan