Hi Deba Am currently on .BB () only so you have to go thru this process yourself.
If you want the % of total billing against bal of billing to achieve then 1. In the Dashboard sheet divide cell F8 by cell G8. Give it a label and then next to it type a 100% and label that also 2. Copy the graph for the % of target achieved and paste it anywhere. 3. Select the copied graph and right click and choose select data ,It will take you to the previous data of the % of target achieved. You have to reselect the data by choosing the new figures you computed. If the graph shows you too bars, right click on the bars and choose format data series And in the seris option make the overlap a 100%. Choose No fill for the 100%. Hope this helps. Sent from my BlackBerry® smartphone from Airtel Ghana -----Original Message----- From: Deba Ranjan <drdeva...@gmail.com> Sender: excel-macros@googlegroups.com Date: Tue, 17 Apr 2012 14:03:58 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Creation of dashboard *Hi Experts, Can you please create for me please. Please find the attached file, there is clearly explain which need to be added chart. thanks in advance * Thanks & Regards,* * *Deba Ranjan P*** MIS - Operation On Tue, Apr 17, 2012 at 12:59 PM, Deba Ranjan <drdeva...@gmail.com> wrote: > *Hi Experts, > > Can you please create for me please. Please find the attached file, > there is clearly explain which need to be added chart. thanks in advance > * > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
