ReportMagic

[Agent.SqlGraph:]

Retrieve SQL data and display in chart form in a report.

This macro is partially execute-restricted. Details in the Usage / Parameters section. See Connection Role Security and / or Restricted Macros.

Purpose

Retrieve SQL data and display in chart form in a report. The query is executed via an Agent Connection.

Macro Compatibility

The macro can be used in all input document types and in Report Studio.

Usage

The first column returned will be used as the X-Axis, following columns are values to graph and will represent one or more series on the Y-Axis and should be numeric; nulls are treated as gaps in the data. Queries that contains the following commands (case-insensitive) are execute-restricted - in this case ask your Tenant Admin to make the Schedule admin-locked, and ensure an Admin has made the Connection accessible to you. The restricted commands are: ADD, ALTER, APPEND, BACKUP, CREATE, DELETE, DROP, EXEC, INSERT, TRUNCATE, and UPDATE.

Parameter	Type	Deprecation Message	Preferred Parameter	Presence	Purpose	Options	Default
connectionString	String			Mandatory	The SQL connection string (an SQL endpoint).	N/A	N/A
sql	String			Mandatory	The SQL to execute. Queries that contains the following commands (case-insensitive) are execute-restricted - in this case ask your Tenant Admin to make the Schedule admin-locked, and ensure an Admin has made the Connection accessible to you. The restricted commands are: ADD, ALTER, APPEND, BACKUP, CREATE, DELETE, DROP, EXEC, INSERT, TRUNCATE, and UPDATE.	N/A	N/A
chartType	List<String>	Deprecated	chartTypes		The type(s) of chart. You can specify more than one (separated by a semi-colon). If you specify fewer than the number of series, the last value will continue to be used for the remainder of the series. Permitted values: Point, FastPoint, Line, Spline, StepLine, FastLine, Bar, StackedBar, StackedBar100, Column, StackedColumn, StackedColumn100, Area, SplineArea, StackedArea, StackedArea100, Pie, Doughnut, Radar, Polar, BoxPlot, Funnel, Pyramid. For Pie and Doughnut chart types, the first column provides the slice name, the second column the slice size and all other columns are ignored.	N/A	N/A
chartTypes	List<String>	Use instead of: chartType		Conditional	The type(s) of chart. You can specify more than one (separated by a semi-colon). If you specify fewer than the number of series, the last value will continue to be used for the remainder of the series. Permitted values: Point, FastPoint, Line, Spline, StepLine, FastLine, Bar, StackedBar, StackedBar100, Column, StackedColumn, StackedColumn100, Area, SplineArea, StackedArea, StackedArea100, Pie, Doughnut, Radar, Polar, BoxPlot, Funnel, Pyramid. For Pie and Doughnut chart types, the first column provides the slice name, the second column the slice size and all other columns are ignored.	N/A	N/A
customPaletteHexCodes	String			Conditional	When the 'overridePaletteType' parameter is set to 'Custom', you must specify a semi-colon separated list of HTML-style hex codes (or HTML colour names such as red), e.g. #FF0000;#00FF00;#0000FF (with or without the hash) to use as a custom override palette, which will apply to each line series plotted. This parameter is ignored unless you use 'overridePaletteType=Custom'.	N/A	N/A
imageHeightCm	Double			Conditional	The image height in centimetres (cm). If this is set, so should 'imageWidthCm' be. For Word output, this is equivalent to setting an absolute height in cm without locking the aspect ratio.	N/A	N/A
imageWidthCm	Double			Conditional	The image width in centimetres. If this is set, so should 'imageHeightCm' be. For Word output, this is equivalent to setting an absolute with in cm without locking the aspect ratio.	N/A	N/A
xAxisLabel	String	Deprecated	xAxisTitle		Set the X Axis Label to the provided text. Required for all chartTypes, except 'Pie' and 'Doughnut'.	N/A	N/A
xAxisTitle	String	Use instead of: xAxisLabel		Conditional	Set the X Axis Label to the provided text. Required for all chartTypes, except 'Pie' and 'Doughnut'.	N/A	N/A
yAxisLabel	String	Deprecated	yAxisTitle		Set the Y Axis Label to the provided text. Required for all chartTypes, except 'Pie' and 'Doughnut'.	N/A	N/A
yAxisTitle	String	Use instead of: yAxisLabel		Conditional	Set the Y Axis Label to the provided text. Required for all chartTypes, except 'Pie' and 'Doughnut'.	N/A	N/A
autoScaleYAxisLabels	Boolean	Use instead of: useYAxisShortLabels		Optional	Whether to use short (auto-scaled) labels in Y-axes (e.g. 10K instead of 10000). Only has an effect when the 'yAxisLabelFormat' parameter is NOT set.	true false	true
autoScaleYAxisLabelsAreData	Boolean			Optional	Whether the short (auto-scaled) labels in Y-axes represent 'data'. In that case these labels are used: B, KB, MB, GB, and TB. When not representing data, the labels used are: K (thousands), M (millions), B (billions), and T (trillions). Only has an effect when 'autoScaleYAxisLabels' is true (the default for that parameter), otherwise ignored.	true false	false
chartAreaBackgroundColor	Color			Optional	The chart area background color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
chartAreaHeightPercent	Int32			Optional	The ChartAreaHeightPercent	From 0 to 100	100
chartAreaWidthPercent	Int32			Optional	The ChartAreaWidthPercent	From 0 to 100	80
chartAreaXPosition	Int32			Optional	The ChartAreaXPosition	From 0 to 100	0
chartAreaYPosition	Int32			Optional	The ChartAreaYPosition	From 0 to 100	0
chartBackgroundColor	Color			Optional	The chart background color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
chartBorderLineColor	Color			Optional	The chart border line color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	Color [Black]
chartBorderLineDashStyle	ChartDashStyle			Optional	The chart border line dash style	Solid NotSet Dash DashDot DashDotDot Dot	Solid
chartBorderLineWidth	Int32			Optional	The chart border line width	N/A	0
chartHeight	Int32			Optional	The chart height in pixels	From 1 to 8000	400
chartImageFormat	ChartImageFormat			Optional	The chart image format	EmfPlus Jpeg Png Bmp Tiff Gif Emf EmfDual	EmfPlus
chartWidth	Int32			Optional	The chart width in pixels	From 1 to 8000	2560
clipBottom	Double			Optional	The number of pixels to clip from the bottom of the image. In PowerPoint, you must manually set the 'chartImageFormat' parameter to either Png or Jpeg, e.g. chartImageFormat=Png	N/A	N/A
clipLeft	Double			Optional	The number of pixels to clip from the left of the image. In PowerPoint, you must manually set the 'chartImageFormat' parameter to either Png or Jpeg, e.g. chartImageFormat=Png	N/A	N/A
clipRight	Double			Optional	The number of pixels to clip from the right of the image. In PowerPoint, you must manually set the 'chartImageFormat' parameter to either Png or Jpeg, e.g. chartImageFormat=Png	N/A	N/A
clipTop	Double			Optional	The number of pixels to clip from the top of the image. In PowerPoint, you must manually set the 'chartImageFormat' parameter to either Png or Jpeg, e.g. chartImageFormat=Png	N/A	N/A
comment	String			Optional	Add a comment to make your document template more readable. The comment is discarded in the output document.	N/A	N/A
connectionName	String			Optional	The name of the Connection.	N/A	N/A
description	String			Optional	The description.	N/A	N/A
doughnutRadius	Int32			Optional	Optionally use to specify the doughnut radius when specifying 'chartType=Doughnut'.	From 0 to 99	60
dynamicYAxis	Boolean			Optional	Whether to more closely show the y-axis variance on charts. Use the 'dynamicYAxisVariancePercent' parameter to control the variance percentage. When set, the 'yAxisMinimum' and 'yAxisMaximum' parameters are ignored. When this parameter is set, the 'yAxisIsLogarithmic' parameter is ignored.Note: when the minimum data value is 0, the y-axis minimum is NOT adjusted.	true false	false
dynamicYAxisVariancePercent	Double			Optional	The variance percentage to use in conjunction with the 'dynamicYAxis' parameter to adjust the y-axis scale. For example, if the maximum y-axis data value was 10 and this parameter was set to 5, then the y-axis maximum is set to 10 + (5% of 10), which is 10.5. When this parameter and 'dynamicYAxis' is set, the 'yAxisMinimum' and 'yAxisMaximum' parameters are ignored.When this parameter and 'dynamicYAxis' is set, the 'yAxisIsLogarithmic' parameter is ignored. NOTE: final y-axis minimum and maximum values will be rounded to the nearest integer (whole number)	From 0 to 100	1.5
emptyTableText	String			Optional	The text for the new tab in the Xlsx document if the table is empty.	N/A	N/A
enable3d	Boolean			Optional	Whether to enable 3D.	true false	false
ensureColorsUnique	Boolean			Optional	Whether to ensure the colours of all series in the chart are unique. Note that unique colours are still selected if no palette is provided for any series.	true false	false
errorOnOverflow	Boolean			Optional	Should NCalc expression evaluation throw error on Overflow	true false	true
failureText	String			Optional	The text to display should the macro fail to execute. Note that a poorly-specified macro (e.g. omitting mandatory parameters) will still result in an error message.	N/A	N/A
fixedLines	List<FixedLine>			Optional	The semicolon-delimited list of lines of fixed y-value to add to the graph. Each should be in the format "name^value^color", e.g. fixedLines=Lower95th^10^Red;Mean^50^Blue;Upper95th^90^Red	N/A	N/A
hAlign	PowerPointImageHorizontalAlign			Optional	For PowerPoint output only, the ability to horizontally align images produced by macros, with vertical lines. No other image parameters apply (clipping, etc.).	Center Left Right	N/A
horizontalPositionAlignment	HorizontalPositionAlignment			Optional	The horizontal position alignment.	Left Inline Center Right Inside Outside	Left
horizontalPositionRelativeTo	HorizontalPositionRelativeTo			Optional	What the horizontal position is relative to.	Inline Margin Column Page InsideMargin OutsideMargin LeftMargin RightMargin	Inline
if	String			Optional	The condition that must be true in order for the macro to be executed/evaluated. Must either evaluate to true or false, for example: "3+5=8" or "contains('abcd', 'z').	N/A	true
inclination3dDegrees	Int32			Optional	The inclination in degrees. Only valid when enable3d is set to true.	From -90 to 90	50
innerPlotHeightPercent	Int32			Optional	The InnerPlotHeightPercent	From 0 to 100	75
innerPlotWidthPercent	Int32			Optional	The InnerPlotWidthPercent	From 0 to 100	85
innerPlotXPosition	Int32			Optional	The InnerPlotXPosition	From 0 to 100	10
innerPlotYPosition	Int32			Optional	The InnerPlotYPosition	From 0 to 100	10
labelBackgroundColor	Color			Optional	The label background color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
labelColor	Color			Optional	The label color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
labelFontSize	Double			Optional	Set the chart label font size.	From 5 to 100	16
labels	List<String>			Optional	Optionally use to specify labels to add to the chart, formatted as: text^X^Y^alignment^font^fontSize^fontStyle^fontColor. Supported fonts are: 'Arial, Calibri, Comic Sans MS, and Ms Sans Serif'. Supported fontStyles are 'Regular, Bold, Italic, Underline, Strikeout'. Supported alignments are TopLeft, TopCenter, TopRight, MiddleLeft, MiddleCenter, MiddleRight, BottomLeft, BottomCenter, BottomRight. Font colours can be named fonts (such as Red) or hex-based colours (ARGB or RGB-formatted such as #FF0000 or #FFFF0000 for red). Note that alpha component is optional.	N/A	N/A
labelText	String			Optional	Optionally use to specify the label text. Options include #PERCENT{P0} (e.g. for Pie/doughnut charts), #VALX and #VALY. The {P-number} specifies the number of decimal places to display. You can combine these and other symbols (e.g. '#VALX\n(#PERCENT %)' ).	N/A	N/A
legendBackgroundColor	Color			Optional	The legend background color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
legendBorderColor	Color			Optional	The legend border color	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
legendFontSize	Double			Optional	Set the chart legend font size (default autofit).	From 5 to 100	20
legendHeightPercent	Int32			Optional	The LegendHeightPercent	From 0 to 100	100
legendStyle	LegendStyle			Optional	The legend style	Column Row Table	Column
legendText	String			Optional	Optionally use to specify the label legend text. For other options, see the labelText parameter.	N/A	N/A
legendTextWrapThreshold	Int32			Optional	The number of characters that can be placed in a legend item before text wrapping occurs. Wrapping uses a 'word-break' method, so if the legend names do NOT contain spaces, no wrapping will occur.	From 0 to 2147483647	25
legendWidthPercent	Int32			Optional	The LegendWidthPercent	From 0 to 100	20
legendXPosition	Int32			Optional	The LegendXPosition	From 0 to 100	80
legendYPosition	Int32			Optional	The LegendYPosition	From 0 to 100	0
lineWidth	Int32			Optional	The line width	From 1 to 10	2
markerBorderColor	ListColor	Use instead of: markerBorderColors		Optional	Set the border color(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerBorderColors	ListColor	Deprecated	markerBorderColor		Set the border color(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerBorderWidth	List<Int32>	Use instead of: markerBorderWidths		Optional	Set the border width(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerBorderWidths	List<Int32>	Deprecated	markerBorderWidth		Set the border width(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerColor	ListColor	Use instead of: markerColors		Optional	Set the color(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerColors	ListColor	Deprecated	markerColor		Set the color(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerSize	List<Int32>	Use instead of: markerSizes		Optional	Set the size(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerSizes	List<Int32>	Deprecated	markerSize		Set the size(s) of the marker (for example, on line charts). If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerStyle	ListMarkerStyle	Use instead of: markerStyles		Optional	Set the marker style(s) (for example, on line charts) If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
markerStyles	ListMarkerStyle	Deprecated	markerStyle		Set the marker style(s) (for example, on line charts) If there are fewer values provided than there are series in your graph, the last one is repeated for the remaining series.	N/A	N/A
mode	MacroMode			Optional	The mode in which variables are stored. In the legacy mode (default for Schedules), the variable created is a string and formatted. In the normal mode (default for Report Studio), the output variable is stored as a strongly-typed object, e.g. an Int32 or a List etc., rather than a formatted string.	Legacy Normal	Legacy
noDataText	String			Optional	The text to insert, instead of a graph, when there is no data. If not set, then you may see a Macro Error instead in this case.	N/A	N/A
obfuscation	ObfuscationType			Optional	Obfuscation type. Use obfuscation to write reports where sensitive data is hidden. When used, ReportMagic guarantees that the same input string will map to the same output string for the whole of the report (but the next time the report runs, it will most likely map to a different value). If you use obfuscation, the property in your macro will not show up and instead, you will see a fake item of the obfuscation type chosen.	None UkTown DeviceName Company IpAddress PrivateIpAddress	None
opacityPercent	Double			Optional	The image opacity (0 is transparent, 100 is solid).	From 0 to 100	100
orderAreaChartSeriesByMean	Boolean			Optional	For charts where all the series are areas (not stacked), order the series according to the mean y-axis values (largest first, descending). This is useful for charts where, depending on the data, 'larger' series would be rendered in front of smaller ones, thereby obscuring them in the chart.	true false	false
overridePaletteType	OverridePaletteType			Optional	Force series colours to use various alternative palettes. Overrides all other settings such as 'EnsureColorsUnique'. When there are more series than the count of colours in each palette, the colours chosen will start again from the beginning of the palette. This parameter is useful for series where there are no colours set (or set to 'Auto' in LogicMonitor Widget graphs, for example).	Default Custom LogicMonitor RainbowStandard RainbowExtended	Default
pageHeightPercent	Double			Optional	The height of the page to take up with the graph. Always overrides 'imageHeightCm'	From 0 to 300	N/A
pageWidthPercent	Double			Optional	The width of the page to take up with the graph. Always overrides 'imageWidthCm'	From 0 to 300	N/A
palette	List<String>			Optional	A list of html-encoded (hex codes) colours for each series separated by ^ for the series name and colour, and semicolons for each series (see examples below). If not specified, a default Microsoft palette will be used. The 'OverridePaletteType' parameter will, if set, override this parameter.	N/A	Yes^#0d0;No^#d00;True^#0d0;False^#d00;OK^#0d0;Error^#d00;Unknown^#ddd
perspective3dPercent	Int32			Optional	The perspective in percent. Only valid when enable3d is set to true.	From 0 to 100	0
pieCollectedColor	Color			Optional	Optionally use to specify the color of the collected ('other') pie slice.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	Color [LightGray]
pieCollectedLabel	String			Optional	Optionally use to specify the label for the collected ('other') pie slice.	N/A	Other
pieCollectedThresholdPercent	Double			Optional	Optionally use to specify the percentage threshold for the collected ('other') pie slice.	From 0 to 100	5
pieLabelStyle	PieLabelStyle			Optional	Optionally use to specify the doughnut radius when specifying 'chartType=Doughnut' or 'chartType=Pie'.	Inside Outside Disabled	Inside
pieLineColor	Color			Optional	Optionally use to specify the pie or doughnut line color when using 'pieLabelStyle=Outside'.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	Color [LightGray]
pieStartAngleDegrees	Int32			Optional	Optionally use to specify the pie or doughnut start angle in degrees from the top.	From 0 to 359	0
pointDepth3dPercent	Int32			Optional	The point depth as a percentage. Only valid when enable3d is set to true.	From 0 to 1000	100
pointGapDepth3dPercent	Int32			Optional	The point gap depth as a percentage. Only valid when enable3d is set to true.	From 0 to 1000	100
pointWidth	Double			Optional	The point width (gap between bar or column chart items)	N/A	N/A
removeNewlineCharacters	Boolean			Optional	Whether to remove newline characters from the SQL.	true false	false
rotation3dDegrees	Int32			Optional	The rotation in degrees. Only valid when enable3d is set to true.	From -90 to 90	30
serverType	SystemAccess.ServerType			Optional	The type of server.	Mssql None Postgres	Mssql
storeAsHidden	String			Optional	The hidden (does not show in document output) variable in which to save the output graph as base64-encoded text. This is useful because the [Variable.Image:] macro can then insert it into any document. The image is generated only once but can then be manipulated repeatedly with a variety of image-related parameters. Note: when this variable is set, the image format will be forced to PNG, i.e. the equivalent of: chartImageFormat=Png. The image is saved unclipped (i.e. without any clip parameters applied).	N/A	N/A
timeoutMs	Int32			Optional	The timeout in milliseconds.	From 1000 to 2147483647	60000
title	String			Optional	The title.	N/A	N/A
titleHeadingLevel	Int32			Optional	The title heading level. Don't specify if no heading is required.	N/A	N/A
useChartMagic	Boolean			Optional	Whether to use ChartMagic (experimental)	true false	false
useYAxisShortLabels	Boolean	Deprecated	autoScaleYAxisLabels		Whether to use short (auto-scaled) labels in Y-axes (e.g. 10K instead of 10000). Only has an effect when the 'yAxisLabelFormat' parameter is NOT set.	true false	true
vAlign	PowerPointImageVerticalAlign			Optional	For PowerPoint output only, the ability to vertically align images produced by macros, with horizontal lines. No other image parameters apply (clipping, etc.).	Bottom Middle Top	N/A
verticalPositionAlignment	VerticalPositionAlignment			Optional	The Vertical position alignment.	Top Inline Center Bottom Inside Outside	Top
verticalPositionRelativeTo	VerticalPositionRelativeTo			Optional	What the vertical position is relative to.	Inline Page Paragraph Margin BottomMargin InsideMargin OutsideMargin TopMargin	Inline
warning	String			Optional	If specified, adds a warning message for this macro. This is processed as an NCalc, and the warning message will ALWAYS be present and will be the value of the evaluated NCalc expression.	N/A	N/A
worksheetName	String			Optional	The worksheet to save the result in the output Excel document (if so configured). Excel does not allow blank names, names above 31 characters, and the following characters: :, /, \, ?, *, [, ]	N/A	Table
wrapping	Wrapping			Optional	Image wrapping.	Inline BehindText	Inline
writeToSpreadsheet	Boolean			Optional	Whether to output the result in the output Excel document (if so configured).	true false	true
xAxisFontColor	Color			Optional	Optionally use to specify the x axis font color.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	Color [Black]
xAxisFontSize	Double			Optional	Set the chart x-axis font size (default autofit).	From 5 to 100	20
xAxisHeightPercent	Double			Optional	Set the chart x-axis height as a percent of the chart area. By default, an automatic choice is made.	From 0 to 90	N/A
xAxisInterval	Double			Optional	The x-axis interval. Only works for whole numbers such as 1, 2, etc. (unpredictable results otherwise).	N/A	N/A
xAxisIntervalAutoMode	IntervalAutoMode			Optional	Optionally use to specify the x axis's interval auto mode.	FixedCount VariableCount	FixedCount
xAxisIntervalType	DateTimeIntervalType			Optional	Optionally use to specify the x axis's interval type. The 'xAxisInterval' parameter is ignored when this parameter is 'Auto' (the default). It is recommended that if you know the type of the date-oriented x-axis (such as months) then you set this parameter accordingly e.g. xAxisIntervalType=Months, and xAxisInterval=1 (to display each month on the x-axis).	Auto Number Years Months Weeks Days Hours Minutes Seconds Milliseconds NotSet	Auto
xAxisIsAutoFit	Boolean			Optional	Whether the x axis's labels are automatically fitted.	true false	true
xAxisIsMarginVisible	Boolean			Optional	Overrides the default x-axis auto margin (which is true by default EXCEPT when there's an empty graph with 2 data points, e.g. a start and an end date). The auto margin extends the x-axis by the equivalent of 1 data point either side of the data, typically leaving a small gap between both interior sides of the axis and the data. Note that in the case of an EMPTY graph (no y-values, but where there is a date / data range), this can lead to an additional month each side of the axis, which may not be what you want to achieve. ReportMagic in this case AUTOMATICALLY disables the margins to produce the 'expected' x-axis range, hence why you may want to force this to true in case you do want the margins.	true false	N/A
xAxisLabelAngle	Int32			Optional	Optionally use to specify the x axis's label angle.	From -90 to 90	0
xAxisLabelAutoFitStyle	LabelAutoFitStyles			Optional	Optionally use to specify the X Axis label autofit style.	DecreaseFont None IncreaseFont StaggeredLabels LabelsAngleStep30 LabelsAngleStep45 LabelsAngleStep90 WordWrap	DecreaseFont
xAxisLabelFormat	String			Optional	The X Axis label format. See https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings for more details.	N/A	yyyy-MM-dd
xAxisLineColor	Color			Optional	The x axis line color.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
xAxisLineDashStyle	ChartDashStyle			Optional	The x axis line dash style	Solid NotSet Dash DashDot DashDotDot Dot	Solid
xAxisLineWidth	Int32			Optional	The x axis line width.	N/A	N/A
xAxisMajorGridEnabled	Boolean			Optional	Whether the X-axis major grid is enabled	true false	true
xAxisMajorGridInterval	Double			Optional	A number - (if specified, you must also specify xAxisMajorGridIntervalType)	From 0 to 100	N/A
xAxisMajorGridIntervalType	DateTimeIntervalType			Optional	The major x-axis grid interval type.	Auto Days Hours Milliseconds Minutes Months NotSet Number Seconds Weeks Years	N/A
xAxisMinorGridEnabled	Boolean			Optional	Whether the X-axis Minor grid is enabled	true false	true
xAxisMinorGridInterval	Double			Optional	A number - (if specified, you must also specify xAxisMinorGridIntervalType)	From 0 to 100	N/A
xAxisMinorGridIntervalType	DateTimeIntervalType			Optional	The Minor x-axis grid interval type.	Auto Days Hours Milliseconds Minutes Months NotSet Number Seconds Weeks Years	N/A
xlsxTableStyle	XlsxTableStyle			Optional	The XLSX table style to use in any XLSX output document.	TableStyleMedium13 None TableStyleDark1 TableStyleDark10 TableStyleDark11 TableStyleDark2 TableStyleDark3 TableStyleDark4 TableStyleDark5 TableStyleDark6 TableStyleDark7 TableStyleDark8 TableStyleDark9 TableStyleLight1 TableStyleLight10 TableStyleLight11 TableStyleLight12 TableStyleLight13 TableStyleLight14 TableStyleLight15 TableStyleLight16 TableStyleLight17 TableStyleLight18 TableStyleLight19 TableStyleLight2 TableStyleLight20 TableStyleLight21 TableStyleLight3 TableStyleLight4 TableStyleLight5 TableStyleLight6 TableStyleLight7 TableStyleLight8 TableStyleLight9 TableStyleMedium1 TableStyleMedium10 TableStyleMedium11 TableStyleMedium12 TableStyleMedium14 TableStyleMedium15 TableStyleMedium16 TableStyleMedium17 TableStyleMedium18 TableStyleMedium19 TableStyleMedium2 TableStyleMedium20 TableStyleMedium21 TableStyleMedium22 TableStyleMedium23 TableStyleMedium24 TableStyleMedium25 TableStyleMedium26 TableStyleMedium27 TableStyleMedium28 TableStyleMedium3 TableStyleMedium4 TableStyleMedium5 TableStyleMedium6 TableStyleMedium7 TableStyleMedium8 TableStyleMedium9	TableStyleMedium13
xValueType	ChartValueType			Optional	The x value type. You can set this to 'String' which will disable the 'Auto' mode for the 'xAxisIntervalType' parameter.	DateTime Auto Double Single Int32 Int64 UInt32 UInt64 String Date Time DateTimeOffset	DateTime
yAxisFontColor	Color			Optional	Optionally use to specify the y axis font color.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	Color [Black]
yAxisFontSize	Double			Optional	Set the chart y-axis font size (default autofit).	From 5 to 100	20
yAxisInterval	Double			Optional	The y-axis interval. Only works for whole numbers such as 1, 2, etc. (unpredictable results otherwise).	N/A	N/A
yAxisIntervalAutoMode	IntervalAutoMode			Optional	Optionally use to specify the y axis's interval auto mode.	FixedCount VariableCount	FixedCount
yAxisIntervalType	DateTimeIntervalType			Optional	Optionally use to specify the y axis's interval type.	Auto Number Years Months Weeks Days Hours Minutes Seconds Milliseconds NotSet	Auto
yAxisIsAutoFit	Boolean			Optional	Whether the y axis's labels are automatically fitted.	true false	true
yAxisIsLogarithmic	Boolean			Optional	Optionally use to specify that the Y Axis is logarithmic. Note that any y values of 0 or below will cause an error. You may need to manually adjust the yAxisMinimum parameter. When the 'dynamicYAxis' parameter is set, this parameter is ignored and the axis is forced NOT to be logarithmic.	true false	false
yAxisLabelAngle	Int32			Optional	Optionally use to specify the y axis's label angle.	From -90 to 90	0
yAxisLabelAutoFitStyle	LabelAutoFitStyles			Optional	Optionally use to specify the Y Axis label autofit style.	DecreaseFont None IncreaseFont StaggeredLabels LabelsAngleStep30 LabelsAngleStep45 LabelsAngleStep90 WordWrap	DecreaseFont
yAxisLabelFormat	String			Optional	The Y Axis label format. See https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings for more details. When this parameter is set, it overrides the 'autoScaleYAxisLabels' parameter (i.e. that one has no effect).	N/A	N/A
yAxisLineColor	Color			Optional	The y axis line color.	A named color or an HTML-encoded color .Note that 'transparent' is a valid color that you can use in any macro parameter that expects a color.	N/A
yAxisLineDashStyle	ChartDashStyle			Optional	The y axis line dash style	Solid NotSet Dash DashDot DashDotDot Dot	Solid
yAxisLineWidth	Int32			Optional	The y axis line width.	N/A	N/A
yAxisMajorGridEnabled	Boolean			Optional	Whether the Y-axis major grid is enabled	true false	true
yAxisMajorGridInterval	Double			Optional	A number - (if specified, you must also specify yAxisMajorGridIntervalType)	From 0 to 100	N/A
yAxisMajorGridIntervalType	DateTimeIntervalType			Optional	The major y-axis grid interval type.	Auto Days Hours Milliseconds Minutes Months NotSet Number Seconds Weeks Years	N/A
yAxisMaximum	Double			Optional	Sets the Y Axis maximum (default derived from graph data). When both yAxisMinimum and yAxisMaximum are set, if either are not whole numbers, this MAY cause chart data to be rendered incorrectly.	N/A	N/A
yAxisMinimum	Double			Optional	Sets the Y Axis minimum (default derived from graph data). This value MAY be automatically adjusted when 'yAxisIsLogarithmic=true' and the data contains any 0 values, to avoid chart errors (logarithmic charts may not contain y-axis values of 0 or below). When both yAxisMinimum and yAxisMaximum are set, if either are not whole numbers, this MAY cause chart data to be rendered incorrectly.	N/A	N/A
yAxisMinorGridEnabled	Boolean			Optional	Whether the Y-axis Minor grid is enabled	true false	true
yAxisMinorGridInterval	Double			Optional	A number - (if specified, you must also specify yAxisMinorGridIntervalType)	From 0 to 100	N/A
yAxisMinorGridIntervalType	DateTimeIntervalType			Optional	The Minor y-axis grid interval type.	Auto Days Hours Milliseconds Minutes Months NotSet Number Seconds Weeks Years	N/A
yAxisWidthPercent	Double			Optional	Set the chart y-axis width as a percent of the chart area. By default, an automatic choice is made.	From 0 to 90	N/A

Examples (1)

Example 1: