how to manage increasing no of rows in xcelcious column chart

[Former Member]

Hi Guys

I am using a column chart by doing a data by series and my repoprting requiremnet is calender month wise value display example

Month S1 S2 S3 S4

01.2010 2 5 6 8

02.2010 4 8 8 2

In the column chart i am selecting category lebel (x) till 12 cells as i will have more months data coming but when i refresh the connection ony two months are coming in chart but when i see it in bi side its more and xcelcious snapshots is also showing only two rows after the dashboard preview.

is there any settings to manage the increasing number of rows. i am in xcelcious 2008 engage SP3 getting data through XML maps.

waiting for your quick response.

Regards

Amiya

[Former Member · Accepted solution]

HI Amiya,

Can u check once the Bindings that you gave to XML Maps and excel sheets.

How many rows did u gave at the time of retreiving the data.

Check it once most of the times that may be the issue.

If you dont know the process of incresing the row size of the XML Map properties, please let me know ill send a

detailed information.

Regards,

AnjaniKumar C.A.

[Former Member · Accepted solution]

Hi

thanks for the reply

i have cheked the binding of the chart multiple timesi have taken 12 cells.

i dont know the process of incresing the row size of the XML Map properties. please let me know.

this might be the reason because its taking the no of rows at the time of adding the xml maps ..

thanks in advance.

regards

Amiya

[Former Member · Accepted solution]

Hi,

Please let me know which version of Office u r using.

Regards,

AnjaniKumar C.A.

[Former Member · Accepted solution]

Hi AnjaniKumar

I am using excel 2007 .

Regards

Amiya

[Former Member · Accepted solution]

Hi Amiya,

Just go to Data Range Properties and set the data range for the cells.

(Right Click on the excel sheet where data is populated).

Regards,

AnjaniKumar C.A.

[Former Member · Accepted solution]

HI

I am not getting any data range property when i right click the cell can you please tell me more specifically the steps to do it.

Regards

Amiya

[Former Member · Accepted solution]

Hi Amiya,

You can select " Data" Menu -

---

> from there you can select "Import External Data" -

---

> Select "Data Range Properties".

This is the case with 2003.

I hope in 2007 you can get the properties from the Data Sources Tab.

Just check in the XML Data Source properties.

I'll let u know the 2007 scenario in few mins(I'll check on other machine).

Regards,

AnjaniKumar C.A.

[Former Member · Accepted solution]

Hi guys

i have tried every options but not got anything does i have to fix the number of rows by creating structures in the query. i think thats the last option left.

Regards

Amiya

[Former Member · Accepted solution]

From my experience, XML Maps are not so flexible. I have not seen a way to expand the range. Probably working with an xml source which returns you the biggest possible data range druing the first import itself may be an option.

I have seen XML Data connection are more flexible. There you have an option of choosing the data range. However some programming may required to remodel you xml out to support the format for XML Data connection.