150
I'm following instructions found here, Modifying Multi-Series Dynamics CRM Charts to Use a Single Axis - CRM Software Blog | Dynamics 365 to remove the secondary axis for a multi-series chart.
I've exported the chart, opened it in Notepad, removed the yAxisType, saved it over the exported XML file, but when I try to import it again, I receive this error:
The specified XML file "Opps--YTD.xml" is either not valid XML or does not conform to the chart schema.
Hi AdmWombat,
I'm glad to hear that. Cheers!
I think I have it working now. I was trying to upload in the form view rather than in advanced settings. It worked in advanced settings.
It's not showing in the list view drop down for charts, but I am able to add the new version to a dashboard.
Sure. This is the version I'm trying to import,
<visualization>
<visualizationid>{9834979b-eec4-ed11-83ff-000d3a565cf9}</visualizationid>
<name>Revenue & Budget--All YTD</name>
<description>null</description>
<primaryentitytypecode></primaryentitytypecode>
<datadescription><datadefinition><fetchcollection><fetch mapping="logical" aggregate="true"><entity name="opportunity"><attribute name="name" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0"/><attribute name="actualvalue" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_0"/><attribute name="estimatedvalue" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_14"/></entity></fetch></fetchcollection><categorycollection><category alias="_CRMAutoGen_groupby_column_Num_0"><measurecollection><measure alias="_CRMAutoGen_aggregate_column_Num_0"/></measurecollection><measurecollection><measure alias="_CRMAutoGen_aggregate_column_Num_14"/></measurecollection></category></categorycollection></datadefinition></datadescription>
<presentationdescription><Chart Palette="None" PaletteCustomColors="91,151,213; 213,112,44; 160,116,166; 178,134,0; 68,114,196; 90,139,56; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 86,122,154; 192,120,72; 167,129,172; 178,143,35; 105,142,208; 112,154,83; 50,125,194; 210,96,18; 150,83,159; 183,138,0; 51,90,161; 90,138,57;"><Series><Series ChartType="Bar" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40"><SmartLabelStyle Enabled="True"/></Series><Series ChartType="Bar" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40"><SmartLabelStyle Enabled="True"/></Series></Series><ChartAreas><ChartArea BorderColor="White" BorderDashStyle="Solid"><AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorGrid LineColor="239, 242, 246"/><MajorTickMark LineColor="165, 172, 181"/><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/></AxisY><AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorTickMark LineColor="165, 172, 181"/><MajorGrid LineColor="Transparent"/><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/></AxisX><AxisY2 LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"> <MajorGrid LineColor="239, 242, 246"/> <MajorTickMark LineColor="165, 172, 181"/> <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59"/> </AxisY2></ChartArea></ChartAreas><Titles><Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59"/></Titles><Legends><Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59"/></Legends></Chart></presentationdescription>
<isdefault>false</isdefault>
</visualization>
Hi AdmWombat,
Could you provide the chart xml?
Hi AdmWombat,
I followed the blog you provided, and I can import it successfully.
Original chart:
Delete the YAxisType property and import chart:
It seems that your chart xml is invalid. Please try to export it and only delete the YAxisType property to try again.
#1
André Arnaud de Cal...
291,642
Super User 2024 Season 2
#2
Martin Dráb
230,371
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
