1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
.. SPDX-License-Identifier: BSD-2-Clause
Copyright 2013-2023, John McNamara, jmcnamara@cpan.org
.. _ex_chart_data_labels:
Example: Charts with Data Labels
================================
A demo of some of the Excel chart data labels options that are available via
an XlsxWriter chart. These include custom labels with user text or text taken
from cells in the worksheet. See also :ref:`chart_series_option_data_labels`
and :ref:`chart_series_option_custom_data_labels`.
Chart 1 in the following example is a chart with standard data labels:
.. image:: _images/chart_data_labels11.png
:scale: 75 %
Chart 2 is a chart with Category and Value data labels:
.. image:: _images/chart_data_labels12.png
:scale: 75 %
Chart 3 is a chart with data labels with a user defined font:
.. image:: _images/chart_data_labels13.png
:scale: 75 %
Chart 4 is a chart with standard data labels and formatting:
.. image:: _images/chart_data_labels22.png
:scale: 75 %
Chart 5 is a chart with custom string data labels:
.. image:: _images/chart_data_labels14.png
:scale: 75 %
Chart 6 is a chart with custom data labels referenced from worksheet cells:
.. image:: _images/chart_data_labels15.png
:scale: 75 %
Chart 7 is a chart with a mix of custom and default labels. The ``None`` items
will get the default value. We also set a font for the custom items as an
extra example:
.. image:: _images/chart_data_labels16.png
:scale: 75 %
Chart 8 is a chart with some deleted custom labels and defaults (set with
``None`` values). This allows us to highlight certain values such as the
minimum and maximum:
.. image:: _images/chart_data_labels17.png
:scale: 75 %
Chart 9 is a chart with custom string data labels and formatting:
.. image:: _images/chart_data_labels23.png
:scale: 75 %
.. literalinclude:: ../../../examples/chart_data_labels.py
|
