| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Certain Data in Table
Hello Everyone. I'm running into a little bit a of an issue when trying to
chart data. I have a very large table that is being queried from a SQL database. I would like to create a "dynamic" chart/graph based on the results from the table. However, I would only like to include certain data (location) and only data for a certain amount. Statement would go something like this - If Location = X and Amount =Y then include the data. Any suggestions? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart Certain Data in Table
Sounds like your query wasn't specific enough.
You could autofilter the table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JWL5537" wrote in message ... Hello Everyone. I'm running into a little bit a of an issue when trying to chart data. I have a very large table that is being queried from a SQL database. I would like to create a "dynamic" chart/graph based on the results from the table. However, I would only like to include certain data (location) and only data for a certain amount. Statement would go something like this - If Location = X and Amount =Y then include the data. Any suggestions? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart Certain Data in Table
The Query was for all non-stock parts in all locations. The user wans the
entire list, but a chart for everything with an on hand of $1000 or greater by location. So this month for Location 1 you could have 15 parts that fit that criteria. However next month, there could be 20 and would like for the chart to auto-update when the query does. "Jon Peltier" wrote: Sounds like your query wasn't specific enough. You could autofilter the table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JWL5537" wrote in message ... Hello Everyone. I'm running into a little bit a of an issue when trying to chart data. I have a very large table that is being queried from a SQL database. I would like to create a "dynamic" chart/graph based on the results from the table. However, I would only like to include certain data (location) and only data for a certain amount. Statement would go something like this - If Location = X and Amount =Y then include the data. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
| Data table in chart? | Charts and Charting in Excel | |||
| Chart Data Table | Charts and Charting in Excel | |||
| Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel | |||
Hybrid Mode
