Line Chart based on Cross Tab

IS it possible to create chart based on crosstab ?

Please look at the attached chart.

I need Collection Time as X-axis and four different lines for 4 different Disk based on their usage.

How can I do that ?

Currently I m doing is, for Y-series - disk used and X- series - collection time.

As you can see it gives no output.

Please guide

Thanks a lot

Find more posts tagged with

Comments

mwilliams

You should be able to use at least the dataCube as the source. You might be able to name the crosstab in the general tab of the property editor and then select the crosstab from drop down as the source in your select data tab.

Have you tried just making the chart from your dataSet? You could make the x-axis the time, the y-axis the usage, and then the optional grouping could be the disk.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75448" data-time="1301955310" data-date="04 April 2011 - 03:15 PM">
You should be able to use at least the dataCube as the source. You might be able to name the crosstab in the general tab of the property editor and then select the crosstab from drop down as the source in your select data tab. 
 
Have you tried just making the chart from your dataSet? You could make the x-axis the time, the y-axis the usage, and then the optional grouping could be the disk. </blockquote>
 
Thanks a lot. It worked