Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a dynamic graph
i have a list of data and i will like to create graphs for a particular
person when needed.here is the format of my raw data. Dept Country Name Jan Feb Mar 1 sg john 50 25 55 alex 40 15 20 1 hk alex 15 20 30 as one person might appear in different country or dept,what can i do to create graph of a particular person so that all data concern with that person no matter which dept or country will be use for the graph to reflect the various figure in various country or dept. i cant use specific cell reference as the data is generated dynamically everyday or anytime when needed so the data will alway be changing. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a dynamic graph
Make one graph of all data.
Use a Data =filter = Autofilter to hide the rows you don't want with the chart selected, go to tools=Options=Chart tab and make sure plot visible cells is checkmarked Another approach would be to create a pivot Table (you will need ot fill in the blank cells) and then create a pivot chart as well. Then selections can be made from the pivot Table/Pivot Chart. -- Regards, Tom Ogilvy "violet" wrote in message ... i have a list of data and i will like to create graphs for a particular person when needed.here is the format of my raw data. Dept Country Name Jan Feb Mar 1 sg john 50 25 55 alex 40 15 20 1 hk alex 15 20 30 as one person might appear in different country or dept,what can i do to create graph of a particular person so that all data concern with that person no matter which dept or country will be use for the graph to reflect the various figure in various country or dept. i cant use specific cell reference as the data is generated dynamically everyday or anytime when needed so the data will alway be changing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range for graph | Excel Discussion (Misc queries) | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
problem with dynamic graph | Excel Worksheet Functions | |||
Creating/programming an Excel dynamic graph | Excel Programming |