Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
todd
 
Posts: n/a
Default excel data label format special number characters (part 2)

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?

  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

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 |:)

"todd" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - pivot table - how do i format cells with data mm/dd/yyyy . Dave Excel Worksheet Functions 1 April 18th 05 05:48 PM
Excel data file format Wordgeek Excel Discussion (Misc queries) 5 March 28th 05 10:02 AM
DOS Data in Excel Format with Date and Military Time in same cell Jules Excel Worksheet Functions 1 March 14th 05 10:31 PM
How to sort/update large excel db [email protected] Excel Discussion (Misc queries) 0 February 2nd 05 01:43 AM
pasting excel data in a powerpoint slide James Excel Discussion (Misc queries) 4 January 28th 05 03:23 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"