What are there markers in the chart when there's no <c:marker> nodes?

David Thielen 61 Reputation points
2021-03-02T23:49:30.337+00:00

Hi all;

Please look at ATE-4761.docx. It has markers (scatter chart). But in chart1.xml there is no c:marker node. I assume there are defaults, but what are they? And does only scatter have markers if no marker node is specified?

thanks - dave

Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
127 questions
Accepted answer
  1. Mike Bowen 1,516 Reputation points Microsoft Employee
    2021-03-04T18:01:53.217+00:00

    Hi Dave,

    The defaults for marker style are in ISO/IEC 29500-1 section 21.2.3.46 ST_Style (Style). They are determined by the value of “val” from the <c:style val=”2”> element. Table 1 shows chart default styles. Some of them have defaults for all style values others use the tables in the section to determine their style from “val”.

    For “Fills for Data Points (2-D)” the defaults come from Table 5. Looking at the Fill, for example, in table 5 for val=”2” the fill is 2. Table 3 has the default fill formatting per chart style, for 2 in Table 3 the color is bg1.

    There are elements besides the scatter that have markers by default, e.g. Line with Markers and Radar with Markers also have markers.

    Let me know if that answers your questions.

    Best,

    -Mike

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest