Probably the best way to do this is to create a dummy series, and only fill
in the entries where you want labels. Let this series run across the bottom
of the chart, don't display the line or markers, but choose the option to
display Data Labels.


--
Cheers,
Shane Devenshire


" wrote:

Hello,

I've been creating a spreadsheet with the daily value of my stock
portfolio, for personal records. Within the spreadsheet, I've created a
chart that shows the daily progression as a line graph. What I want to
do, is the X-axis (day value) display a label on the first trading day
of each week. Right now I'm given the option of placing a label every
number of days (ticks), but given that trading weeks vary in length due
to holidays, it doesn't end up the way I want. I'm also not given the
choice of starting after a few days, so the first label will always be
on the first day I started trading, which wasn't a Monday.
Is there a simple way of placing labels where I want, instead of
automatically?
Many thanks!

Diego