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
