Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart Data from external data source
Hi all,
I am trying to create a pivot chart to extract data thro an MS SQL database which is of the form:- Country City House Age XXX yyy 1 C XXX yyy 1 C XXX yyy 1 T XXX yyy 1 T XXX yyy 1 T XXX yyy 1 A I need to get the data in the form: Country City House C T A XXX YYY 1 2 3 1 and further create a chart selectable on a per house basis. Is this simple to implement? thanks, VRA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
Selected Columns to be Used in External Data Source in Pivot Table | Excel Discussion (Misc queries) | |||
DATE FORMAT IN PIVOT TABLE FROM EXTERNAL DATA SOURCE | Excel Discussion (Misc queries) | |||
Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
Pivot and changing External data source | Excel Discussion (Misc queries) |