Custom axis label frequency

[correo]

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

 

[ShaneDevenshire]

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.

 

[ShaneDevenshire]

I should add that you may want to use the XL ChartLabler Add-in which is free
on the internet.

If you need more detail let me know.

 

[Jon Peltier]

If the label shows the date, then the chart labeler (http://appspro.com) is
unnecessary. In a column next to the data you're plotting, put either 0 (or
whatever the Y axis minimum is) beside the dates where you want a label, or
=NA() where you don't want a label. Add a series using this column, format
it to show no line and no markers, and add data labels, using the Show
Labels option. The NA() points will not be plotted on the chart, so they
will have no labels either. Format the labels with the desired date format,
and format the label position to below the points.

- Jon

 

[Jon Peltier]

Of course, if you need something different as the labels, you need to put
the labels in the next column, next to the 0 (or Y axis minimum) values. Add
the invisible series as before. Then use the chart labeler to apply the
column of labels to the hidden series.

- Jon