excel data label format special number characters (part 2)

[todd]

Addendum to Previous post:
I realized I omitted one crucial element from my previous post: I want the
fractional data label to be a non-simplified representation of the source
data (e.g. - if the source data is 10/6, I want the data label to be 10/6).

Previous post:
I'm trying to create bar graphs containing fractional data labels. The catch
is, I want each bar in the series to have a different denominator value.
Excel allows you to preset the denominator (e.g. - ?/4), but that denominator
affects all members of that series. The question is, is this do-able and if
so what special character(s) allow(s) my task to be performed?

 

[CyberTaz]

Hi Todd-

Not 100% clear on your issue, but this may be on track.

Once you click a bar to select the series you can click any bar in the
series to select just that Data Point. Rt-click it and go to Format Data
Point.

Maybe even more useful once you have a Data Label applied you can use the
same technique to modify each directly:

If labels are on the entire series, click a label, click it again to focus
on it, then click again to treat it as a 'textbox' and

a) select the label content and type what you want, or

b) click in the Formula Bar, type =, then click a sheet tab and select a
cell to link the label to. It will display whatever is in the related cell
and update like any other formula if the cell content changes.

HTH |:>)