You're welcome Shyam... On Thu, Feb 11, 2010 at 5:31 PM, $...@mmy <shyam.utha...@gmail.com> wrote:
> Hi Abhishek, > > Thanks a ton for solving my problem... > > Cheers > Shyam > > > On 11 February 2010 17:17, Abhishek Jain <abhishek....@gmail.com> wrote: > >> Hi Saroj, >> >> A warm welcome to the group! >> >> Thank you very much for your kind words but there is nothing extraordinary >> I did in this. I think you missed the email I sent to Shyam mentioning the >> steps. The same is being reproduced hereunder - >> >> >> > I took screenshot of your background (RAG). (Printscreen) >> > Cropped it to remove other unnecessary things. - (Crop it in Office >> Picture Manager or Excel, Powerpoint, wherever you like) >> >> > Saved it as a separate picture. >> > Used the picture in filling the graph. (Right-Click>Format Chart >> Area>Fill Effects>Picture) >> > Removed the gridlines, legends, etc. >> > Resized the plot area to fit to the picture. >> >> If you wish to populate the value of marks in the graph, right click on >> the chart, select chart options, under Data Labels tab, check 'Y Value'. >> >> However, there is a difference there - Shyam's background was colored on >> the basis of values (I guess), but in this case I just used it as a picture >> to fill the graph so whenever you resize the graph, the axises and the >> picture will differ....oye! >> >> Putting a picture in the background of a graph doesn't make me a >> genius....does it ? :) >> >> Cheers! >> >> Abhishek >> >> On Thu, Feb 11, 2010 at 12:45 PM, saroj.32006 <saroj.32...@gmail.com>wrote: >> >>> Hi AJ, >>> >>> My name is saroj, i m new joinee to this group but been viewing all the >>> e-mails and quieries with their masterminded solutions. I was some how able >>> to analyse the solution and founded the formula which has been used to solve >>> a certain quiery. This time i got stuck with your great technique. Kindly >>> tell me how did u incorporated the no.s in the graph.....I am unable solve >>> it. >>> >>> Thank you, >>> >>> Saroj. >>> >>> On Thu, Feb 11, 2010 at 10:43 AM, Abhishek Jain >>> <abhishek....@gmail.com>wrote: >>> >>>> Hi Shyam, >>>> >>>> I have updated the graph as per your below requirements. Please see the >>>> attached file - is this what you looking for ? >>>> >>>> Thanks, >>>> >>>> AJ >>>> >>>> >>>> On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy <shyam.utha...@gmail.com> wrote: >>>> >>>>> Hi Rock, >>>>> >>>>> Thanks for the response. It works partially. >>>>> >>>>> Ok let me get the criterias up: >>>>> >>>>> >>>>> 1. I would need the RAG (in the back ground as shown in the excel) >>>>> 2. I would need the Diagonal Bisecting the Chart too. >>>>> >>>>> Will this be possible? I tried to do a combo.. but with out any >>>>> success! >>>>> >>>>> Regards >>>>> Shyam >>>>> >>>>> >>>>> On 9 February 2010 17:10, Rock <rak_sha...@yahoo.co.in> wrote: >>>>> >>>>>> Hi Sammy, >>>>>> >>>>>> You can use the XY (Scatter) chart the create this. >>>>>> >>>>>> Regards >>>>>> Rakesh >>>>>> >>>>>> >>>>>> On Feb 9, 9:54 am, "$...@mmy" <shyam.utha...@gmail.com> wrote: >>>>>> > Hi All, >>>>>> > >>>>>> > Could any one help me out with plotting the attached graph. >>>>>> Currently I get >>>>>> > them manually adjusting the dots based on the axis. >>>>>> > >>>>>> > Is there a way where in i get the variables in the table and the >>>>>> Graph gets >>>>>> > automatically updated? >>>>>> > >>>>>> > Regards >>>>>> > Shyam >>>>>> > >>>>>> > Graph.xlsx >>>>>> > 16KViewDownload >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>>>> http://www.excelitems.com >>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>> >>>>>> >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> If you find any spam message in the group, please send an email to: >>>>>> Ayush Jain @ jainayus...@gmail.com >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> HELP US GROW !! >>>>>> >>>>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>>>> about the learning and support from the group.Let friends and co-workers >>>>>> know they can subscribe to group at >>>>>> http://groups.google.com/group/excel-macros/subscribe >>>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>>> http://www.excelitems.com >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> If you find any spam message in the group, please send an email to: >>>>> Ayush Jain @ jainayus...@gmail.com >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe