Macro to create a chart from a dynamic range. Help!

eddy

Well-known Member
Joined
Mar 2, 2002
Messages
521
I have a sheet (MainSheet) with rows of data.
The columns I am intersested in
are C (Which contains the date in the format 28/08/2002)
F (Which contains four options say either RED,GREEN,BLUE or YELLOW)
G (Which contains the number of items sold on that day)


I have another sheet (Stats). Within this sheet I would like to have a macro
which would select data from A6 down to the last row entry in G
Then be able to select data between two dates( C column) e.g 01/08/2002 - 01/09/2002
Then shown a graph containing numbers (G Col) of RED,GREEN, BLUE and YELLOW (F Col)
sold during the defined period.

I dont want to use Pivot Tables. Just enter a search from date and a serch to date

Any ideas appreciated.

eD
This message was edited by eddy on 2002-10-03 13:07
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
There are rather a lot of questions here.

I suggest you start by turning on the macro recorder, selecting your range and plotting the chart. That should get you started with the syntax.

You could use Dropdowns on a UserForm for your date selection. Set the RowSource to the dates on your worksheet.

Search this Board for "last cell" for help in finding the last used cell in a column.
 

eddy

Well-known Member
Joined
Mar 2, 2002
Messages
521
Thanks Andrew but it's not that simple. I need quite a lot of code which is not recordable!
The search and data colation between the "inputtable" dates is the difficult bit.
eD
 

Watch MrExcel Video

Forum statistics

Threads
1,128,138
Messages
5,628,919
Members
416,353
Latest member
Nenza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top