chart with modified axis

[oleg mirzaev]

Hi all,
i need to create an axis but in week units for example 201316 represents week 16 in year 2013. Thus after 201352 the next number need to be 201401 and NOT 201353.
How can i do it in x axis?

example:
axis.jpg

excel:
trial_Reply.xlsx

thanks in advance!

[gjcase]

Assuming you have a date column in col A, then add a column B with the following formula:

=Year(A1)& Weeknum(A1)

And copy that down. then use the new col B as your axis column.

[oleg mirzaev]

how can i use those values as x-axis?

[Andy Pope]

You will need to recalculate values for bar length and data marker positions.

You can then use a dummy series to plot axis labels to match you scaling.

[oleg mirzaev]

what if my data may change, added, reduced? will i be able to make those changes automatically?

[Andy Pope]

If you use formula then I don't see why not.