none
What do c:ser/c:idx and c:ser;c:order do? RRS feed

  • Question

  • 21.2.2.84 idx says:

    This element specifies the index of the containing element. This index shall determine which of the parent's children collection this element applies to.

    What/where is this index used? I don't see anything where these index values can be applied.

    One item of note, these values are unique across all charts and series in each chart.

    21.2.2.128 order says:
    This element specifies the order of the series in the collection. It is 0 based.

    I'm guessing this is the order in which this series is listed in the series drop-down in chart formatting. Is that its sole purpose?


    What we did for the last 6 months - Made the world's coolest reporting & docgen system even more amazing

    Wednesday, November 14, 2018 4:29 PM

All replies

  • Hi,

    Could you provide more detailed information, such as the links you see?

    Best Regards,

    Bruce

    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    Thursday, November 15, 2018 9:48 AM
    Moderator
  • Sure - here's a chart1.xml file with several series:

    <?xml version="1.0" encoding="UTF-8"?>
    <c:chartSpace xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart" xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:c16r2="http://schemas.microsoft.com/office/drawing/2015/06/chart">
    	<c:date1904 val="0"/>
    	<c:lang val="en-US"/>
    	<c:roundedCorners val="0"/>
    	<mc:AlternateContent xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006">
    		<mc:Choice xmlns:c14="http://schemas.microsoft.com/office/drawing/2007/8/2/chart" Requires="c14">
    			<c14:style val="102"/>
    		</mc:Choice>
    		<mc:Fallback>
    			<c:style val="2"/>
    		</mc:Fallback>
    	</mc:AlternateContent>
    	<c:chart>
    		<c:autoTitleDeleted val="0"/>
    		<c:plotArea>
    			<c:layout/>
    			<c:barChart>
    				<c:barDir val="col"/>
    				<c:grouping val="clustered"/>
    				<c:varyColors val="0"/>
    				<c:ser>
    					<c:idx val="0"/>
    					<c:order val="0"/>
    					<c:tx>
    						<c:v>2011</c:v>
    					</c:tx>
    					<c:invertIfNegative val="0"/>
    					<c:cat>
    						<c:strLit>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>Apr</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>May</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>Jun</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>Jul</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>Aug</c:v>
    							</c:pt>
    						</c:strLit>
    					</c:cat>
    					<c:val>
    						<c:numLit>
    							<c:formatCode>General</c:formatCode>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>1</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>2</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>3</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>#N/A</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>#N/A</c:v>
    							</c:pt>
    						</c:numLit>
    					</c:val>
    				</c:ser>
    				<c:ser>
    					<c:idx val="1"/>
    					<c:order val="1"/>
    					<c:tx>
    						<c:v>2010</c:v>
    					</c:tx>
    					<c:invertIfNegative val="0"/>
    					<c:cat>
    						<c:strLit>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>Apr</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>May</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>Jun</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>Jul</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>Aug</c:v>
    							</c:pt>
    						</c:strLit>
    					</c:cat>
    					<c:val>
    						<c:numLit>
    							<c:formatCode>General</c:formatCode>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>4</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>5</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>#N/A</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>17</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>8</c:v>
    							</c:pt>
    						</c:numLit>
    					</c:val>
    				</c:ser>
    				<c:ser>
    					<c:idx val="2"/>
    					<c:order val="2"/>
    					<c:tx>
    						<c:v>2009</c:v>
    					</c:tx>
    					<c:cat>
    						<c:strLit>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>Apr</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>May</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>Jun</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>Jul</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>Aug</c:v>
    							</c:pt>
    						</c:strLit>
    					</c:cat>
    					<c:val>
    						<c:numLit>
    							<c:formatCode>General</c:formatCode>
    							<c:ptCount val="5"/>
    							<c:pt idx="0">
    								<c:v>#N/A</c:v>
    							</c:pt>
    							<c:pt idx="1">
    								<c:v>9</c:v>
    							</c:pt>
    							<c:pt idx="2">
    								<c:v>8</c:v>
    							</c:pt>
    							<c:pt idx="3">
    								<c:v>#N/A</c:v>
    							</c:pt>
    							<c:pt idx="4">
    								<c:v>7</c:v>
    							</c:pt>
    						</c:numLit>
    					</c:val>
    				</c:ser>
    				<c:dLbls>
    					<c:showLegendKey val="0"/>
    					<c:showVal val="0"/>
    					<c:showCatName val="0"/>
    					<c:showSerName val="0"/>
    					<c:showPercent val="0"/>
    					<c:showBubbleSize val="0"/>
    				</c:dLbls>
    				<c:gapWidth val="150"/>
    				<c:axId val="394604144"/>
    				<c:axId val="394606768"/>
    			</c:barChart>
    			<c:catAx>
    				<c:axId val="394604144"/>
    				<c:scaling>
    					<c:orientation val="minMax"/>
    				</c:scaling>
    				<c:delete val="0"/>
    				<c:axPos val="b"/>
    				<c:numFmt formatCode="General" sourceLinked="1"/>
    				<c:majorTickMark val="out"/>
    				<c:minorTickMark val="none"/>
    				<c:tickLblPos val="nextTo"/>
    				<c:crossAx val="394606768"/>
    				<c:crosses val="autoZero"/>
    				<c:auto val="1"/>
    				<c:lblAlgn val="ctr"/>
    				<c:lblOffset val="100"/>
    				<c:noMultiLvlLbl val="0"/>
    			</c:catAx>
    			<c:valAx>
    				<c:axId val="394606768"/>
    				<c:scaling>
    					<c:orientation val="minMax"/>
    				</c:scaling>
    				<c:delete val="0"/>
    				<c:axPos val="l"/>
    				<c:majorGridlines/>
    				<c:numFmt formatCode="General" sourceLinked="1"/>
    				<c:majorTickMark val="out"/>
    				<c:minorTickMark val="none"/>
    				<c:tickLblPos val="nextTo"/>
    				<c:crossAx val="394604144"/>
    				<c:crosses val="autoZero"/>
    				<c:crossBetween val="between"/>
    			</c:valAx>
    		</c:plotArea>
    		<c:legend>
    			<c:legendPos val="r"/>
    			<c:overlay val="0"/>
    		</c:legend>
    		<c:plotVisOnly val="1"/>
    		<c:dispBlanksAs val="gap"/>
    		<c:extLst>
    			<c:ext xmlns:c16r3="http://schemas.microsoft.com/office/drawing/2017/03/chart" uri="{56B9EC1D-385E-4148-901F-78D8002777C0}">
    				<c16r3:dataDisplayOptions16>
    					<c16r3:dispNaAsBlank val="1"/>
    				</c16r3:dataDisplayOptions16>
    			</c:ext>
    		</c:extLst>
    		<c:showDLblsOverMax val="0"/>
    	</c:chart>
    	<c:printSettings>
    		<c:headerFooter/>
    		<c:pageMargins b="0.75" l="0.7" r="0.7" t="0.75" header="0.3" footer="0.3"/>
    		<c:pageSetup/>
    	</c:printSettings>
    </c:chartSpace>
    


    What we did for the last 6 months - Made the world's coolest reporting & docgen system even more amazing

    Thursday, November 15, 2018 12:17 PM
  • Bruce - any updates?

    What we did for the last 6 months - Made the world's coolest reporting & docgen system even more amazing

    Monday, January 28, 2019 2:14 PM