Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 -- deejayh ------------------------------------------------------------------------ deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110 View this thread: http://www.excelforum.com/showthread...hreadid=551832 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit my chart | Charts and Charting in Excel | |||
Chart Property Confusion | Charts and Charting in Excel | |||
HELP with this function | Excel Worksheet Functions | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
Stacked column and column combo chart | Charts and Charting in Excel |