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

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

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.
--
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

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, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
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.
--
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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
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, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
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.
--
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