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 <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.
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 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>
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.
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/
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.
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/>
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 361 |
Nodes: | 16 (2 / 14) |
Uptime: | 123:34:51 |
Calls: | 7,716 |
Files: | 12,861 |
Messages: | 5,727,956 |