Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
15
Category Chart with no blank/white spaces for empty values
posted

I was wondering how i might go about trying to create a multi-category-chart column chart similar to this one i created in excel

Has anybody got a good example of how this done?

In the category example http://jsfiddle.net/4gkezf8j/ removing a data point results in white-space

data = [
{ "Year": "1995", "China": 1297, "India": 920, "United States": 266 },
{ "Year": "2005", "China": 1216, "India": 1090, "United States": 295 },
{ "Year": "2010", "China": 1271, "United States": 314 },
{ "Year": "2015", "China": 1361, "India": 1251, "United States": 322 },
{ "Year": "2020", "China": 1381, "India": 1341, "United States": 342 },
{ "Year": "2025", "China": 1394, "India": 1466}
];

My data structure in excel to produced my chart would be like the below

 Diversified   Industrial   Multi-family   Office   Other   Retail 
Diversified Diversified Fund 3                  6.57
Diversified Fund 1                  6.30
Diversified Fund 6                  7.63
Sector Average                  6.83
Industrial AMP Capital Diversified Property Fund               7.06
ISPT Core Fund               7.34
Industrial Fund 8               7.73
Sector Average               6.57
Multi-family Multi-family Fund 1                     6.48
Multi-family Fund 2                     5.47
Multi-family Fund 4                     7.98
Sector Average                     6.48
Office AMP Capital Diversified Property Fund        6.84
ISPT Core Fund        6.73
ISPT 50 Lonsdale        6.63
Office Fund 1        6.44
Sector Average        6.60
Other ISPT Core Fund       7.55
Other Fund 1       6.89
Other Fund 2       6.90
Other Fund 3       7.17
Other Fund 4       7.32
Sector Average       7.07
Retail AMP Capital Diversified Property Fund       6.33
Retail Fund 13       6.54
Retail Fund 14       8.35
Retail Fund 15       6.72
Sector Average       6.97
  • 16210
    Offline posted

    Hi Glen,

    This is expected. What would you expect to see anyway rendered, if there is no value for the category ?

    If you go for the igDataChart instead of the igCategoryChart, you may try how the unknownValuePlotting option will affect the rendering, though it is not expected to work for category type series as well.