web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Chart Import Error: not valid XML or does not conform to the chart schema

(0) ShareShare
ReportReport
Posted on by 166

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.

I have the same question (0)
  • Suggested answer
    Steve Zhao2 Profile Picture
    Microsoft Employee on at

    Hi AdmWombat,

    I followed the blog you provided, and I can import it successfully.

    Original chart:

    pastedimage1679392316845v1.png

    Delete the YAxisType property and import chart:

    pastedimage1679392371161v2.png

    It seems that your chart xml is invalid. Please try to export it and only delete the YAxisType property to try again.

  • mcrthomas Profile Picture
    166 on at

    Exact same error. Tried it in Chrome as well as Edge. Also tried to Export and Import with no changes, but I get the same error.

  • Steve Zhao2 Profile Picture
    Microsoft Employee on at

    Hi AdmWombat,

    Could you provide the chart xml?

  • mcrthomas Profile Picture
    166 on at

    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>

  • mcrthomas Profile Picture
    166 on at

    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.

  • Steve Zhao2 Profile Picture
    Microsoft Employee on at

    Hi AdmWombat,

    I'm glad to hear that. Cheers!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

#3
ManoVerse Profile Picture

ManoVerse 45 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans