I have made a chart that I have been using for a few months.
The chart works well, however I would like to have the time show on the chart.
Could someone help me with this?
The blue and red bars on the chart represent AM and PM respectively.
What is the bwest way to have the time, that the test was taken, show on-above-below-inside doesn't matter, but show on the chart itself?
Dynamic Glucose Chart
-
stans
- Lounger
- Posts: 38
- Joined: 26 Feb 2010, 14:01
Dynamic Glucose Chart
You do not have the required permissions to view the files attached to this post.
-
HansV
- Administrator
- Posts: 78650
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Dynamic Glucose Chart
Excel supports only one set of data labels for a series, so you'll have to choose between the values and the times - you can't have both.
For the times, you'd have to create a range with the times relevant to the chart; I have placed it below the chart (perhaps that's already sufficient for your purpose?)
You can then use Rob Bovey's free add-in XY Chart Labeler.
See the attached version.
For the times, you'd have to create a range with the times relevant to the chart; I have placed it below the chart (perhaps that's already sufficient for your purpose?)
You can then use Rob Bovey's free add-in XY Chart Labeler.
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans