Removing the secondary series in a chart

So you want to create a chart that has both the estimated and actual revenue of opportunities, simple right, yes in principle.

When you configure this simple chart, by default you are left with 2 series right and left showing different scales for the $ amounts, based on the data like below:

Secondary Series post 1

What I really want is one series, one scale and easy comparison, so how do I remove the secondary column?

It’s simple of course, just need follow these simple steps:

  1. From the chart options menu, select export chart
  2. Open the chart in a text editor
  3. Search for the following string – YAxisType=”Secondary“
  4. Now delete this string but don’t remove the />
  5. Save the file
  6. Now back in Dynamics, select import chart and select the new file
  7. Follow the wizard for importing and you are done
  8. Your chart should now look like this.

Secondary Series post 2

Simple, you can now apply this to any chart with a secondary axis. Happy Charting.

Advertisements