Line chart: is there a way to place first left grid line between first and second category labels?

[fabiospark]

I'm building a portfolio performance line chart.
The length of the charted period (in working days) can be changed
through a combo box that dynamically changes the charted range.

All the periods in the list are a multiple of one week (5 working days) so the first day
on the left it will always be a friday. Each series plot will start in the same point
as all of their values are zeroes because I'm evaluating the performance of each series
against their friday values that so become a common floor.

To easily see where the weeks start (between friday and monday) I'm thinking to use
a grid with 5 points between each vertical lines but in this way, as far as I know, the first
left line of the grid will be on the left border of the plotting area, to the left of the first
category. Instead it would be very useful to be able to make the grid vertical lines start AFTER
the first category instead of BEFORE, as it normally is.

See the picture for a two weeks and a three weeks charts.


Thanks for listening.

 

[teylyn]

All the periods in the list are a multiple of one week (5 working days) so the first day
on the left it will always be a friday.

That's weird. Why does a five weekday period start with a Friday?

Instead it would be very useful to be able to make the grid vertical lines start AFTER
the first category instead of BEFORE,

before? The grid lines are either ON the points or BETWEEN the points, depending on how the X axis is defined.

Can you post a data sample, a simple chart with the "before" and then describe what should be different in the "after"?[/QUOTE]

 

[fabiospark]

That's weird. Why does a five weekday period start with a Friday?

The values in the data set are the portfolio (LM1, LM2, LM3, FM3) value recorded at the end of the day so
the friday values are the friday evening values, after the markets closing. As they will remain the same
until monday morning I see them as the starting point of the week and use them as the starting value
agaist which to evaluate the performance from than on. And as I want to see the common starting point
of each series (zero values) I need to include the first friday as the starting day of the period.

before? The grid lines are either ON the points or BETWEEN the points, depending on how the X axis is defined.

Can you post a data sample, a simple chart with the "before" and then describe what should be different in the "after"?

As you can see in the pictures I posted the vertical lines are BETWEEN two categorie,s and the leftmost one is right on top of the plotting area left border.

Thanks.

 

[teylyn]

You can't have chart grid lines in the positions you describe. You need to use helper series in an XY Scatter chart to simulate the grid lines. With that technique you can place them wherever you need.