Seamus2626
asked on
Bubbles / Data / Charts
Hi,
I have attached a spreadsheet where I have a bubble in graph 1.
(1) I want the number -14 to format as a % I.E. -14%
(2) If the number is negative I want the bubble to fill as red if its negative and green if its positive (both with white bold text)
(3) is there a way from preventing the numbers from slipping over the bars (as in 14,950)
Im trying to make this report as automated as possible!
Many thanks
EE.xlsx
I have attached a spreadsheet where I have a bubble in graph 1.
(1) I want the number -14 to format as a % I.E. -14%
(2) If the number is negative I want the bubble to fill as red if its negative and green if its positive (both with white bold text)
(3) is there a way from preventing the numbers from slipping over the bars (as in 14,950)
Im trying to make this report as automated as possible!
Many thanks
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
(2) im going to post this a separate q, and I can do this on the pivot refresh event
(3) is unnecessary
Thanks Glenn!