Chart Certain Data in Table

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?
 
J

Jon Peltier

Sounds like your query wasn't specific enough.

You could autofilter the table.

- Jon
 
J

JWL5537

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Certain Table Data 1
Display Data Table in chart but don't show plot area 2
Stopping a chart when the data runs out 9
Plot value at top of chart 1
How to include variance data in the chart table but not on the gra 1
Remove a column but not data table entry 4
Totals in the data table but not in the graph / chart 1
Chart x axis problem 1

Top