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?

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?

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?