| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Selectable Criteria
I have some cells with sales figures in them. Currently there is a simple bar
graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
You could apply an autofilter to the source data. By default, data in hidden
rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
How would I set up the Auto Filter, I am not familiar enough with filters to
be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
The autofilter has its own dropdowns. You simply need a data range with
column headers. Select the range, go to Data Filter Autofilter. Then use the dropdowns to make your selections. A chart based on the entire range will update based on these selections. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... How would I set up the Auto Filter, I am not familiar enough with filters to be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
Thanks so much! It's working for one criteria, now I just have to get it to
work for the second...I have the 12 months across a row, and then I have 5 or 6 criteria going down column A, but if I select the row, it wants to sort by the numbres that are in the corresponding cells below the months...is there a way to filter by the months (column headings)? "Jon Peltier" wrote: The autofilter has its own dropdowns. You simply need a data range with column headers. Select the range, go to Data Filter Autofilter. Then use the dropdowns to make your selections. A chart based on the entire range will update based on these selections. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... How would I set up the Auto Filter, I am not familiar enough with filters to be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
The Autofilter only filters out rows. Maybe you need a pivot table & pivot
chart. You would need to change your data layout, though, so that you have a column for Month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... Thanks so much! It's working for one criteria, now I just have to get it to work for the second...I have the 12 months across a row, and then I have 5 or 6 criteria going down column A, but if I select the row, it wants to sort by the numbres that are in the corresponding cells below the months...is there a way to filter by the months (column headings)? "Jon Peltier" wrote: The autofilter has its own dropdowns. You simply need a data range with column headers. Select the range, go to Data Filter Autofilter. Then use the dropdowns to make your selections. A chart based on the entire range will update based on these selections. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... How would I set up the Auto Filter, I am not familiar enough with filters to be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
I will work on it, I don't really know what a pivot table is either haha.
Thank you for your help though! "Jon Peltier" wrote: The Autofilter only filters out rows. Maybe you need a pivot table & pivot chart. You would need to change your data layout, though, so that you have a column for Month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... Thanks so much! It's working for one criteria, now I just have to get it to work for the second...I have the 12 months across a row, and then I have 5 or 6 criteria going down column A, but if I select the row, it wants to sort by the numbres that are in the corresponding cells below the months...is there a way to filter by the months (column headings)? "Jon Peltier" wrote: The autofilter has its own dropdowns. You simply need a data range with column headers. Select the range, go to Data Filter Autofilter. Then use the dropdowns to make your selections. A chart based on the entire range will update based on these selections. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... How would I set up the Auto Filter, I am not familiar enough with filters to be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Selectable Criteria
Start here, follow the links to the various tutorials:
http://peltiertech.com/Excel/Pivots/pivotstart.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I will work on it, I don't really know what a pivot table is either haha. Thank you for your help though! "Jon Peltier" wrote: The Autofilter only filters out rows. Maybe you need a pivot table & pivot chart. You would need to change your data layout, though, so that you have a column for Month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... Thanks so much! It's working for one criteria, now I just have to get it to work for the second...I have the 12 months across a row, and then I have 5 or 6 criteria going down column A, but if I select the row, it wants to sort by the numbres that are in the corresponding cells below the months...is there a way to filter by the months (column headings)? "Jon Peltier" wrote: The autofilter has its own dropdowns. You simply need a data range with column headers. Select the range, go to Data Filter Autofilter. Then use the dropdowns to make your selections. A chart based on the entire range will update based on these selections. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... How would I set up the Auto Filter, I am not familiar enough with filters to be able to attach such a thing to a drop down menu "Jon Peltier" wrote: You could apply an autofilter to the source data. By default, data in hidden rows is not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "GoodTrouble" wrote in message ... I have some cells with sales figures in them. Currently there is a simple bar graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of options with only one being selectable? | Excel Discussion (Misc queries) | |||
| How do I add N/A to a selectable cell with an arrow? | Excel Worksheet Functions | |||
| want a list of selectable names on my worksheet | Excel Worksheet Functions | |||
| How do I make a line non-selectable? | Excel Discussion (Misc queries) | |||
| How do I insert a selectable circle in Excel? | Excel Worksheet Functions | |||
Linear Mode
