bar chart with 2 x-axis

sonysunny4u

<p>Hello,</p>
<p>            Need some help, i need to produced multiple Y-axis bar chart on 2 X-axis values.</p>
<p> </p>
<p>For example:</p>
<p> </p>
<p> </p>
<p>Population by zip code for female, male and total for State female, Male</p>
<p> </p>
<p> </p>
<p> </p>
<p>State Zipcode     male   Female</p>
<p> </p>
<p>MI       49006      30           28</p>
<p>MI       49002       32          34</p>
<p> </p>
<p> </p>
<p> </p>
<p>Bar chart </p>
<p> </p>
<p>Y-axis will be Male, Female</p>
<p> </p>
<p>X-axis should be Zipcode, State(at state level i need so summarize and how one bar)</p>
<p> </p>
<p> </p>

kclark

<p>From "select chart type" you can select "secondary axis" from the "Multiple Y Axis" drop down.  Then in "Select Data" you can drag "male" and "female" into their own axis.  This will sum them on the same bar.</p>