Hi Rajan, See below and attached. The first three are DOR (days of receivables) in days and second three are the amounts associated with these accounts.
DOR in DaysInventory in m$ AccountWIPAR TotalWIPAR Total ABC5645101 6.517.524DEF 68351036.313.2 19.5GHI344579 3.44.57.9JKL 5525802.20.93.1 MNO80 251051.3 1.62.9PQR3215 473.80.34.1 STU3425592.43.2 5.6VWX346599 1.23.44.6YZ 25 25503.65.69.2 TOTAL 30.750.2 80.9 On Tue, Jun 5, 2012 at 7:56 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > Can you please provide sample data also?**** > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shishir Ranjan > *Sent:* 05 June 2012 11:30 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Creating a Chart with bubble on it**** > > ** ** > > Hi David and Joseph and everyone,**** > > ** ** > > Here is a pic hope this helps in explaining what I am looking for. I have > omitted the names but this is for few accounts, the data table is on the > right.**** > > ** ** > > Please let me know if you have any more questions and also how to create > such report.... or any other suggestion on explaining this data through a > chart.. looking for some innovative meaningful chart.**** > > ** ** > > Regards**** > > Shishir**** > > ** ** > > On Mon, Jun 4, 2012 at 10:55 PM, <joseph.cam...@gmail.com> wrote:**** > > Also remember, a bubble chart has third variant, that specifies the bubble > size. > > Thanks, > Joseph**** > > Sent on my BlackBerry® from Vodafone**** > ------------------------------ > > *From: *David Grugeon <da...@grugeon.com.au> **** > > *Sender: *excel-macros@googlegroups.com **** > > *Date: *Tue, 5 Jun 2012 10:46:32 +1000**** > > *To: *<excel-macros@googlegroups.com>**** > > *ReplyTo: *excel-macros@googlegroups.com **** > > *Subject: *Re: $$Excel-Macros$$ Creating a Chart with bubble on it**** > > ** ** > > Could you post a picture of the chart you are talking about?**** > > On 5 June 2012 08:01, SR <shishir.ran...@gmail.com> wrote:**** > > > I have seen a report in my company which shows on two axis - the two > parameters of an account and a line connects to these and there is a bubble > placed on the line to indicate the volume,**** > > ** ** > > OK to simplify - it is basically an AR related report - on one axis - it > shows - how many days old past due - on the other axis - it shows - how > many days it takes to bill (billing delays in days) and then a line > connects these two and points and on this line, a bubble shows how much > inventory (volume of AR past due + amount to be invoiced i.e. total > inventory).**** > > ** ** > > I can provide more information but I need to create such report for a > dashboard ... **** > > ** ** > > All help shall be highly appreciated...**** > > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com**** > > > > **** > > ** ** > > -- > David Grugeon**** > > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com**** > > > > **** > > ** ** > > -- > ~Cheers > Shishir**** > > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- ~Cheers Shishir -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
DOR Us account details.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
