+ Reply to Thread
Results 1 to 2 of 2

Chart - slect month by Combo box

  1. #1
    Registered User
    Join Date
    05-04-2006
    Location
    Nottingham, England
    Posts
    16

    Arrow Chart - slect month by Combo box

    I have a sheet where I have some VBA macros, one is to import data from some closed workbooks and pull all the information into a sheet called import, with loads of data as follows;
    Store Date s1 s2 s3
    Store 1 Feb 2005 3 3 2
    Store 1 Mar 2005 1 4 4
    Store 2 Mar 2005 5 2 2
    Store 1 Apr 2005 4 4 4
    Store 2 Oct 2005 4 2 1
    Store 5 Jun 2005 3 2 3
    There could be over 400 rows, with each Store appearing each month.
    I then have a macro to sort all the data by month.

    I need to make a chart in another sheet (Chart1) to give each score (s1, s2,s3) its own graph for each month.
    I was looking to add a combo box to select the month then for the chart to change to reflect the month - How???
    Thanks,
    Dave

  2. #2
    Jon Peltier
    Guest

    Re: Chart - slect month by Combo box

    This might get you started:

    http://peltiertech.com/Excel/Charts/ChartByControl.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "deejayh" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I have a sheet where I have some VBA macros, one is to import data from
    > some closed workbooks and pull all the information into a sheet called
    > import, with loads of data as follows;
    > -Store Date s1 s2 s3-
    > Store 1 Feb 2005 3 3 2
    > Store 1 Mar 2005 1 4 4
    > Store 2 Mar 2005 5 2 2
    > Store 1 Apr 2005 4 4 4
    > Store 2 Oct 2005 4 2 1
    > Store 5 Jun 2005 3 2 3
    > There could be over 400 rows, with each Store appearing each month.
    > I then have a macro to sort all the data by month.
    >
    > I need to make a chart in another sheet (Chart1) to give each score
    > (s1, s2,s3) its own graph for each month.
    > I was looking to add a combo box to select the month then for the chart
    > to change to reflect the month - How???
    > Thanks,
    > Dave
    >
    >
    > --
    > deejayh
    > ------------------------------------------------------------------------
    > deejayh's Profile:
    > http://www.excelforum.com/member.php...o&userid=34110
    > View this thread: http://www.excelforum.com/showthread...hreadid=551832
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1