ExcelBanter - Chart Certain Table Data

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Chart Certain Table Data (https://www.excelbanter.com/charts-charting-excel/195176-chart-certain-table-data.html)

JWL5537

Chart Certain Table Data

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?

JWL5537

Chart Certain Table Data

Sorry for the double post!

"JWL5537" wrote:

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?

All times are GMT +1. The time now is 02:36 AM.