I am having some issues with a barchart plot I am hoping that someone can help me with. My issue is stemming from the fact that I have two different series I am using, doing a side-by-side barplot, and the two series have a different order for the categories that make up the x-axis.
Here is an example:
Table1:
Medium Total Sales
Internet $100,000
Phone $75,000
Email $50,000
Fax $25,000
Table2:
Medium Total Sales
Internet $100,000
Email $75,000
Phone $50,000
Fax $25,000
In my "Select Data" I created two series. One Series is grabbing the Total Sales from Table 1, and the second series is grabbing the total sales from Table 2. For the "Horizontal Axis Selection", I was grabbing the "Medium"s from Table 1. Most of the time, the ordering on these is the same, but in this case it isnt. What is happening is my Bar Chart is plotting "Phone" from Table 1 against "Email" in Table 2.
Is there a way to do this plotting from two different tables that might have a different sort order for the Horizontal Axis labels, and have it match up correctly?
Here is an example:
Table1:
Medium Total Sales
Internet $100,000
Phone $75,000
Email $50,000
Fax $25,000
Table2:
Medium Total Sales
Internet $100,000
Email $75,000
Phone $50,000
Fax $25,000
In my "Select Data" I created two series. One Series is grabbing the Total Sales from Table 1, and the second series is grabbing the total sales from Table 2. For the "Horizontal Axis Selection", I was grabbing the "Medium"s from Table 1. Most of the time, the ordering on these is the same, but in this case it isnt. What is happening is my Bar Chart is plotting "Phone" from Table 1 against "Email" in Table 2.
Is there a way to do this plotting from two different tables that might have a different sort order for the Horizontal Axis labels, and have it match up correctly?