I have 2 columns of figures: date, and time of day (showing when an
event occurred).

I plot these on a scatter diagram: date along X-axis, time up the
Y-axis. This shows me patterns in the occurrences of the events.

I would like to annotate the diagram with vertical lines on specific
dates and to annotate these lines with a brief description (indicating a
change in equipment settings).

Can anybody help me achieve this please?

TIA.


--
Graham J

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Fri, 8/16/2024 1:17 PM, Graham J wrote:

I have 2 columns of figures: date, and time of day (showing when an event occurred).

I plot these on a scatter diagram: date along X-axis, time up the Y-axis.  This shows me patterns in the occurrences of the events.

I would like to annotate the diagram with vertical lines on specific dates and to annotate these lines with a brief description (indicating a change in equipment settings).

Can anybody help me achieve this please?

TIA.

Format Data Labels : Value From Cells : Select Range ?

https://www.ablebits.com/office-addins-blog/find-data-point-excel-scatter-graph/

Maybe you will need a series of cells containing the text you want or something.
Then select one of the cells and associate it with the need to label.

Paul

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Chris wrote:

Graham J <nobody@nowhere.co.uk> wrote:

I have 2 columns of figures: date, and time of day (showing when an
event occurred).

I plot these on a scatter diagram: date along X-axis, time up the
Y-axis. This shows me patterns in the occurrences of the events.

I would like to annotate the diagram with vertical lines on specific
dates and to annotate these lines with a brief description (indicating a
change in equipment settings).

Can anybody help me achieve this please?

It's really hard to interpret what you mean. Can you give an example of
what you mean? Ideally with some (dummy) data.

I will try a better description:

The events are disconnections of a broadband service. Some days there
are none, other days show one or two disconnections overnight. These night-time disconnections occur more frequently around dusk and dawn,
and a diagram plotted over the past 3 months shows the events loosely
following sunrise and sunset times. I suspect the disconnections are
caused by the operation of a security light.

On a specific date I changed the router. After this date the connection reliability improved somewhat, suggesting that the new router is more
noise immune. I would like to show this date with a vertical line on my
chart.

I could print it out and draw the line with a pen and ruler. But it
would be nice to create it in the chart itself.

Clearly there was a disconnection at the time the router was changed. I
have tried simply annotating that event, but when I try my spreadsheet
does not behave in the way described on sites such as:

<https://www.ablebits.com/office-addins-blog/find-data-point-excel-scatter-graph/>

I find I can select all the data points. But I can't select just one.
I suspect all the on-line guides refer to a more modern version of Excel
- mine is the 2010 version. And the guides are explaining how to do
something much more complicated than what I actually need.



--
Graham J

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 8/18/2024 2:34 AM, Graham J wrote:

Chris wrote:

Graham J <nobody@nowhere.co.uk> wrote:

I have 2 columns of figures: date, and time of day (showing when an
event occurred).

I plot these on a scatter diagram: date along X-axis, time up the
Y-axis.  This shows me patterns in the occurrences of the events.

I would like to annotate the diagram with vertical lines on specific
dates and to annotate these lines with a brief description (indicating a >>> change in equipment settings).

Can anybody help me achieve this please?

It's really hard to interpret what you mean. Can you give an example of
what you mean? Ideally with some (dummy) data.

I will try a better description:

The events are disconnections of a broadband service.  Some days there
are none, other days show one or two disconnections overnight.  These night-time disconnections occur more frequently around dusk and dawn,
and a diagram plotted over the past 3 months shows the events loosely following sunrise and sunset times.  I suspect the disconnections are
caused by the operation of a security light.

On a specific date I changed the router.  After this date the connection reliability improved somewhat, suggesting that the new router is more
noise immune.  I would like to show this date with a vertical line on my chart.

I could print it out and draw the line with a pen and ruler.  But it
would be nice to create it in the chart itself.

Clearly there was a disconnection at the time the router was changed.  I have tried simply annotating that event, but when I try my spreadsheet
does not behave in the way described on sites such as:

<https://www.ablebits.com/office-addins-blog/find-data-point-excel-scatter-graph/>

I find I can select all the data points.  But I can't select just one. I suspect all the on-line guides refer to a more modern version of Excel -
mine is the 2010 version.  And the guides are explaining how to do
something much more complicated than what I actually need.

I tried this on my version 2007. and did not have the options available
in the video I'll link. I could do the annotations, just not able to
select the data properly from a cell. or rather a range of cells. I
believe you are correct that you cannot do just one. What I think you
will have to do is provide a column for the annotations and the ones
you don't want anything in you simply leave blank.

I also think you are going to have a hard time getting a line included
instead of text. But I'll have to check out my 2021 version and see
what it can do.

<https://www.youtube.com/watch?v=dxnzxr-tMew>

--
Stand With Israel!

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

sticks wrote:

[snip]

I also think you are going to have a hard time getting a line included instead of text.  But I'll have to check out my 2021 version and see
what it can do.

<https://www.youtube.com/watch?v=dxnzxr-tMew>

Thanks. So I will print it and annotate it by hand, with pen and ruler.

--
Graham J

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Mon, 8/19/2024 2:35 AM, Graham J wrote:

sticks wrote:

[snip]

I also think you are going to have a hard time getting a line included instead of text.  But I'll have to check out my 2021 version and see what it can do.

<https://www.youtube.com/watch?v=dxnzxr-tMew>

Thanks.  So I will print it and annotate it by hand, with pen and ruler.

You could print to PDF and annotate the PDF.

https://www.makeuseof.com/windows-11-annotate-pdfs/

That site is advertising-heavy, and not all that convincing.
Still, it's an illustration of a keyword search for "annotate PDF".

*******

I found it easier, to drop my PDF onto the GIMP tool menu, which
opens the file. Since the file is PDF, it will ask what resolution
you want. Set the resolution to 300. The jaggies won't be quite as
jaggy at 300 DPI.

The file then opens (it uses GhostScript for conversion of .ps or .pdf
to a pixmap - later versions may use another method).

I selected a 9 point pencil width, and a 108 point font,
and annotated (that's because by selecting 300DPI, there is
a degree of magnification). Next, I selected "print" in GIMP, to print the pixmap
as a PDF. I set the margins to zero inches (since the original document
was 8.5"x11" when dropped onto GIMP), and selected Microsoft Print to PDF.
This ghastly looking Metro menu appeared, I selected Letter size paper,
and it saved my single page of output.

When drawing with the GIMP pencil, various combinations of control keys (ctrl-shift while drawing), give nice straight lines.

And to my surprise, the document was 8.5"x11" and for once, not ruined!!!
You cannot copy text out of the document in that case, since now it's
a 300DPI pixmap, scaled down to fit as the background of page 1 of 1 pages. But, at least it is annotated. The red text is my annotation.

[Picture]

https://i.postimg.cc/QCzCpw8y/annotated-PDF-via-GIMP-plus-Print-To-PDF.gif

The viewing tool is Okular. I have two copies of it. One runs in Windows.
One runs in WSL. I selected Okular, not because it was good, but
because it was "not Adobe". Adobe "updated" my Acrobat Reader once
too often, ruining it, and I dumped it and left a comment with them.

Paul

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Chris wrote:

[snip]

IMO Excel is not very flexible for doing atypical things so have to hack
it to do approximately what you want. Try this: https://www.exceldemy.com/add-a-marker-line-in-excel-graph/

That appears to describe what I want to achieve. Thanks. I will try to understand it when I work through it this evening.


--
Graham J

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Graham J wrote:

Chris wrote:

[snip]

IMO Excel is not very flexible for doing atypical things so have to
hack it to do approximately what you want. Try this:
https://www.exceldemy.com/add-a-marker-line-in-excel-graph/

That appears to describe what I want to achieve.  Thanks.  I will try to understand it when I work through it this evening.

None of the useful options shown in the guide appear in the right-click
menus in Excel 2010. So, what I did:

I have 2 columns: Date, and Time. I add 2 more columns, labelled VDSL
(for the change from ADSL to VDSL) and Router (for the change of
router). Both these columns are blank except for a single entry in each
on the date that the change was made. I used text, but the value is
shown on the plot as a zero; so I suspect all that is required is a
non-blank entry.

I create the scatter plot using all 4 columns. The plots named VDSL and
Router appear as different shaped dots (a red square, and a green
triangle) plotted on the x-axis. The right hand margin identifies these
dots using the column titles: Time, VDSL, Router.

So I can insert data points when new events occur, and they appear on
the scatter plot.

If I need a further annotation, I would add another column dedicated to
it. The new annotation would appear as a different coloured or shaped
blob. Not ideal, but adequate for the moment.

Thanks for the support and guidance.

--
Graham J

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 8/19/2024 4:28 PM, Graham J wrote:

None of the useful options shown in the guide appear in the right-click
menus in Excel 2010.

FYI, Stack Social has Office 2021 today for $40. I bought one from them
for my new computer when I just couldn't do anything with the 2003 I
had. A while later I decided to upgrade my laptop and went with their
2019 version which they usually have on sale for $30. Very little
difference in the two versions.

<https://www.stacksocial.com/>

--
Stand With Israel!

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 8/19/2024 5:24 PM, sticks wrote:

On 8/19/2024 4:28 PM, Graham J wrote:

None of the useful options shown in the guide appear in the
right-click menus in Excel 2010.

FYI, Stack Social has Office 2021 today for $40.  I bought one from them
for my new computer when I just couldn't do anything with the 2003 I
had.  A while later I decided to upgrade my laptop and went with their
2019 version which they usually have on sale for $30.  Very little difference in the two versions.

<https://www.stacksocial.com/>

Actually, today the 2019 is only $24.97, $5 less than I remembered.

--
Stand With Israel!

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)