Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating a chart
Hi All,
In DATA! I keep historical prices of my inventory. Items are listed in Columm A, Date & Price are in Rows. I recorded a macro to create a chart for one item. However, I'd like to have a macro to prompt me for the item and then create the chart. Could you help me with this? you help is greatly appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating a chart
What do you mean by item?
-- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "ALLDREAMS" wrote in message ... Hi All, In DATA! I keep historical prices of my inventory. Items are listed in Columm A, Date & Price are in Rows. I recorded a macro to create a chart for one item. However, I'd like to have a macro to prompt me for the item and then create the chart. Could you help me with this? you help is greatly appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating a chart
the items in my inventory. I list them horizontally, the
dates and prices for each item go in rows vertically. -----Original Message----- What do you mean by item? -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "ALLDREAMS" wrote in message ... Hi All, In DATA! I keep historical prices of my inventory. Items are listed in Columm A, Date & Price are in Rows. I recorded a macro to create a chart for one item. However, I'd like to have a macro to prompt me for the item and then create the chart. Could you help me with this? you help is greatly appreciated! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating a chart
Hi ALLDreams,
Here is a "non-elegant" solution: Assume you have items "a", "b" and "c" in your first column (column 1) 1. Select all items (and dates and prices) 2. Create the chart you want 3. Select the entire area and apply autofilter. 4. Use a macro with the following code: Dim SelectedItem as String SelectedItem=Inputbox("Enter Item :") 'Error checks and validation Selection.AutoFilter Field:=1, Criteria1:=SelectedItem Your chart will automatically update for item you have entered. Regards Leni -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with automating creation of Pie Chart(s) | Charts and Charting in Excel | |||
Automating bubble chart colours | Charts and Charting in Excel | |||
Automating best Fit for a Chart | Charts and Charting in Excel | |||
Automating chart with groups. | Charts and Charting in Excel | |||
automating chart generation from text files | Excel Programming |