Chart Certain Data in Table

  • Thread starter Thread starter JWL5537
  • Start date Start date
J

JWL5537

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
 
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.
 
Back
Top