User (Legacy) Posted January 27, 2006 Report Share Posted January 27, 2006 I'm trying to create a chart that shows 12 months worth of sales data. I have something currently that shows the months along the bottom of the chart. The data is summed up into months. The default x-axis runs from 0 to 11. The chart style is lines (not bars). What I'm trying to do is create a vertical line where the exact day of the year is in the chart. My first thought for accomplishing this was to create a new X series running from 0 to 364. I would then make all the values hidden and 0, and make one value on the appropriate day that was equivalent (or close to) the max for the chart. The new series would be displayed as bars. My thought was that, though the default x axis was 12 units across, my new secondary axis would be 365 units across. I thought they would "merge" on top of each other, and the single vertical bar would then show the day. It doesn't, however, work like this. As soon as you add in a point for, say, day 252, the chart just expands out to the right by that amount. You may ask why I don't just show the sales data by day and make a second axis showing month for display purposes. The reason is that the chart HAS to show sums for months and months only, and that data is calculated in a large proc in the database. So, I feel that I'm stuck with displaying the data using only 12 values for a series. For the final month, I'm calculating the "projected" sales amount for the month (ie., given the fact that it's day 20 of the month, and given that there's 10 days remaining, and given that we've sold $60 worth of stuff so far, assume that the current month should show $90). The line representing the day shows us "where" in the month we are, so it informally gives us a visual cue as to our actual sales so far that month. So, my question is: how can I achieve my goal of showing a vertical line for the day? I'm comfortable with drawing via a graphics object if that's what I need to do. I've only been programming against ChartFx for a day, so code samples are appreciated. Thanks! --Shaun Link to comment Share on other sites More sharing options...
Software FX Posted January 28, 2006 Report Share Posted January 28, 2006 A Vertical Line can easily be achieved using a Constant Line (Custom Gridlines in Version 7). A Constant Line can be associated to the X-Axis, and it can have any value on the axis range including values in BETWEEN labels. For example if your axis goes from 0 to 11, each unit representing a month, you can set the value of the constant line to be a say 6.5 which will mean July 15 (6 = July, 0.5 = 15 Days). -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted February 1, 2006 Author Report Share Posted February 1, 2006 Excellent, that does the trick. Thanks! "Software FX Support" <noreply@softwarefx.com> wrote in message news:HygIP0DJGHA.2756@webserver3.softwarefx.com... >A Vertical Line can easily be achieved using a Constant Line (Custom >Gridlines in Version 7). > > A Constant Line can be associated to the X-Axis, and it can have any > value on the axis range including values in BETWEEN labels. > > For example if your axis goes from 0 to 11, each unit representing a > month, you can set the value of the constant line to be a say 6.5 which > will mean July 15 (6 = July, 0.5 = 15 Days). > > -- > Francisco Padron > www.chartfx.com > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.