Skip to Content
avatar image
Former Member

Xcelsius Stacked bar (manual scaling ) seems to have bug!

Hello team,

Need some help.

I have an excelsius stacked bar chart with 2 series, each displaying some start date and end date of projects.

Eg: series1 shows a list of column values for 'start dates'. ( within excel portion)

Series 2 shows a list of column values for 'end dates' of projects

Now when i display the chart with X axis having two series data, and Y axis labels displaying corresponding project names.

I see the start dates and end dates correct when using 'Auto X axis' scale option ( Behavior - > Scale ), but then the scale value

is too big, i mean it displays dates from mid 19 century to mid 20th century ( where in the date range falls between 2007 - 2022)

So, we decided to go for 'manual scale option' ( Behavior - > Scale ), now the problem starts,

Manual scale option will not display the end dates range correctly, it stretches the bar till the max date value (for all projects)

(which seems to be bug).

The same data which displays correct when in auto scale options will no more display accurate.

I even tried using third series to obscure the second series values, however the 3rd series will not even shows up in manual scale. ( though auto scale is working good for 3rd series as well )

Note: The 'end date' values are calculated using the 'Start dates' with a help of a formula.

Please have a look at this scenario

I can send the xlf file to you.

Appreciate your help.

-Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 15, 2009 at 09:11 PM

    I actually figured some thing over here,

    When i select smaller values for either series 'i.e' 50, 69, 80, 25 etc it is working good

    But when i select bigger values like 2000, 2007, 2008, 2020 etc... it seems to have an issue.

    -Ravi

    Add comment
    10|10000 characters needed characters exceeded