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?

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" <(E-Mail Removed)> wrote in message
news:11F2C49F-17A2-4797-8A97-(E-Mail Removed)...
> 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?

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" <(E-Mail Removed)> wrote in message
> news:11F2C49F-17A2-4797-8A97-(E-Mail Removed)...
> > 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?
>
>
>