Profile Picture

Area Chart

Posted By Prabaharaprabu... 14 Years Ago

Area Chart

Author
Message
Prabaharaprabu...
cry Posted 14 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 14 Years Ago
Posts: 3, Visits: 1

Using Area Chart X axis as Datetime with 10 Year Data and Y-Axis as $ value data look likes as below

Name - Category - Date - Amount
A      Fund     1987-06-12 00:00:00.000            10000.000000
A         Index     1987-06-30 00:00:00.000            10710.000000
A         Fund     1988-06-30 00:00:00.000            12928.310000
A         Fund     1988-09-30 00:00:00.000            13234.190000
A         Fund     1988-12-31 00:00:00.000            13842.350000
A         Fund     1989-03-31 00:00:00.000            15864.390000
A         Fund     1989-06-30 00:00:00.000            17273.370000
A         Fund     1989-09-30 00:00:00.000            18521.010000

A         Fund     1989-12-31 00:00:00.000            17298.710000

A         Fund     1990-03-31 00:00:00.000            16366.520000

A         Fund     1990-06-30 00:00:00.000            16897.510000

A         Fund     1990-09-30 00:00:00.000            12838.330000

A         Fund     1990-12-31 00:00:00.000            14100.180000

A         Fund     1991-03-31 00:00:00.000            16656.210000

B 1987-06-12 00:00:00.000            10000.000000

B 1987-06-30 00:00:00.000            10000.000000

B  1987-09-30 00:00:00.000            10645.963567

B 1987-12-31 00:00:00.000            8119.244471

B 1988-03-31 00:00:00.000            8914.431673

B 1988-06-30 00:00:00.000            9471.667674

B 1988-09-30 00:00:00.000            9112.724339

B 1988-12-31 00:00:00.000            9169.187336

B 1989-03-31 00:00:00.000            9747.260872

B 1989-06-30 00:00:00.000            10705.115278

B 1989-09-30 00:00:00.000            11986.287557

B 1989-12-31 00:00:00.000            12055.521946

B 1990-03-31 00:00:00.000            11631.377293

B 1990-06-30 00:00:00.000            12626.873697

B 1990-09-30 00:00:00.000            10070.578745

B 1990-12-31 00:00:00.000            11437.117698

B 1991-03-31 00:00:00.000            14076.090609

B 1991-06-30 00:00:00.000            13857.632587

B 1991-09-30 00:00:00.000            14994.286482

B 1991-12-31 00:00:00.000            16815.890300

 

How to do that in Area chart,the X axis must be in the range of 2 yeard difference.
Any Help!
Thanks

 

 

Attachments
Chart3_Series.rscx (160 views, 105.00 KB)
Nevron Support
Posted 13 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Hi Prabaharaprabu,

You'll have to switch the area chart in XY scatter mode. Then you have so assign values and Xvalues(dates) from the data value groupings editor. Finally the date time axis should be configured to use custom step of two years. To do that go to Primary X scale, Scale switch the Sub Type to "Date Time" and, switch step mode to custom step and then specify 2 years as the date time step.



Best Regards,
Nevron Support Team


Similar Topics


Reading This Topic