Thanks Kishan for your reply. However, it's not exactly what I'm looking for.
If you take a look at the worksheet I downloaded, "Net Sales Chart.xls", I would like to do the following: 1. Under the "Select the period to plot" drop down menu, I'd like to select the appropriate month rather than the FY which I now have set up in the first menu box. 2. Once the month is selected from the drop down menu, the graph should automatically be updated with the current information from the table shown below the graph based on both the FY selected and the chosen month. 3. I would like to repeat steps 1 and 2 for the quarter and also the YTD. Any additional thoughts or comments are appreciated. Steve On Jul 28, 2:28 am, "Kishan Reddy, K" <kishanreddy.kethire...@gmail.com> wrote: > Hello, > > Obviously you will have a data sheet on which you have created the > graph. > > Just right clik on the graph and select source data > > It will show the data on which graph is drawn. > > Just reselect the range that you want and press OK > > done. > > Bye > Kishan Reddy, K. > > On Jul 28, 4:43 am, Steve <stevebwea...@comcast.net> wrote: > > > > > I need help! > > > I am trying to adapt a neat little spreadsheet for my use in graphing > > monthly, quarterly, and year-to-date sales for the current year and a > > comparison to the same period in the prior year. What I have so far > > has been downloaded. > > > How can I select the appropriate period to plot i.e. month, quarter, > > or year-to-date? > > > Thank you in advance for your help. > > > Steve- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
