I am using the MS query feature in Excel to import data from a SQL database.
I am inputing several parameters (start date/time, stop date/time, tagname)
from parameters linked to Excel cells (user modifiable).
The data is returned as a date/time column and corresponding data column.
The query works fine but only when I limit it to returning the date/time and
one other column of data.
If I try and return multiple data columns (in addition to the date/time) I
get error message:
"parameters are not allowed in queries that can't be represented graphically"
Is there any way around this without resorting to programing the query with
VB?

I tried resorting to a Pivot table for the data but I could not figure out
how to automatically update the Pivot table when the query updated?

{It also took me forever to figure out how to link the MS Query parameters
to Excel cells - you use ?'s in the query and then must supply something to
fill-in the parameter as you close MS Query. Then you can link the
parameters to Excel cells by right clicking on the data field - none of this
is well documented}

Thanks