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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s