Hi all,
Can any one know how to increase the marker size just for one point… I have a line chart and the X-axis lies for 13 month period… But the end user wants to differentiate the current month w.r.t the Prior 12 months… So, he wants to increase the Current month Marker size… Is there a way to do it…
Thanks in Advance…
listener (BOB member since 2011-04-26)
No that is not possible - but there is another solution to distinguish current month from other months.
You could create two series with two different colors.
The first series will pick up all 13 months. Then the second series would pick up only the first 12 months. This will give the appearence that there is only one line but the current month will be a different color.
I use this solution to show actuals and forecast on one line.
Make sense?
Greg
greg.wayne 
(BOB member since 2010-09-28)
Hi Greg,
Thanks for your prompt response… Here I hav 3 series in this graph… One is to show regions, the other one for Zones and the third one for Professionals… So, I used the size 6 for the markers… Where as the clients would like to distinguish that difference between the current month and the rest…in only 1 graph…For the appearance they would like to see the big round…on the last or current month for all these 3 series… Not sure how to make it… Is there a way to make it hardcoded atleast…
listener (BOB member since 2011-04-26)
No, unfortuanately that is an xcelsius limitation. If the dashboard is being updated monthly you could use an image component and just move it every month. Not very practicle but would work
greg.wayne (BOB member since 2010-09-28)
But is there a way can help me out to just hardcode (using ellipse Component) only in the last point or marker of the graph(Current month) of view using some excel functions help…
listener (BOB member since 2011-04-26)
It is possible to create your own xcelius components with the SDK. If you are familiar with actionscript you may be able to develop a chart that meets your needs.
Sorry, I have no experience with creating custom components or actionscript.
greg.wayne (BOB member since 2010-09-28)
I am not using any SDK here… It’s a general questions in our Xcelsius 2008 SP-3, We got a line chart based on the Month like 13 month period with 3 series in a graph… But one of the client would like to see the marker size of the current month like(we have a series of months like( Jan 2010, feb 2010… Jan 2011)He would like to see the marker size current month which is jan 2011 is some what bigger or anything different from others… Technically I think it is not possible but is there a way to hardcode any other components or is it possible to do some manual stuff any suggestions would be greatly appreciated… struggling to get resolved this issue… It would be a great help if some one has encountered such kind of situations based on your experience that would be great…
Thanks in Advance!!!
listener (BOB member since 2011-04-26)
Take a look at the attached example .
This will allow your client to see the current month “different” from prior months.
example.zip (542.0 KB)
greg.wayne 
(BOB member since 2010-09-28)
Hi,
Thanks for sending that Xlf file… Here is the file attached based on the requirement the last month Apr-11 should be different from others as how you designed… Here I already have a 3 series…Please look in to that and let me know…
Thanks for your help in advance…
sample.zip (7.0 KB)
listener (BOB member since 2011-04-26)
Great effort!!! So, You have used rectangle and image components instead legends… I tried the one which you sent earlier… I cannot see the legend properly may be with 6 series… More over here the problem is underneath there is a spreadsheet table in our requirement when we click on one of the zone that zone should populate … So, the legend is linked to the Table… Can this rectangle and other stuff can link to that spreadsheet table to pulate the data…
Thanks in Advance…
listener (BOB member since 2011-04-26)
Sure that is defintiely possible.
In the example I gave you I just covered up the ledgend. Ideally, I would remove the ledgend from the chart and manual create. Then just make the text for the ledgend dynamically change/linked to the spreadsheet table.
The ledgend is small detail. I’d build all the functionality first then go back and incorporate the ledgend.
greg.wayne (BOB member since 2010-09-28)
Yep, Wonderful thanks and moreover hw did you get those images… beacuse I don’t have those images…Do we can save from somewhere… Thanks for your help…
listener (BOB member since 2011-04-26)
For the images I just did a screen print of the icon on the Chart. I use Snagit but a decent free alternative is greenshot.
greg.wayne (BOB member since 2010-09-28)
That make sense… But here in my requirement based on the hierarchy that shape has to be changed… Is it possible in that case…???
listener (BOB member since 2011-04-26)