View Single Post
  #3   Report Post  
Steve
 
Posts: n/a
Default

Thanks for the insight. Any idea on how to fix the problem and show both?

"Kassie" wrote:

It does not really change to a stacked bar chart. To illustrate, once you
have set your axis, right click on one of them, then click on format data
series. Now click on options, and change the gap width to say 40. You will
see that your percentages line up with the relevant axis, while the numbers
line up with the other axis. The one axis will be above, and the other axis
below the graph.

"Steve" wrote:

I have a 2 data item column graph for 6 data points in time. One in %, one
is a number. I want to use a 2 axis graph, but when I try and change the
axis on one of the data items the graph switches to a stack bar graph with 2
axis. Any thoughts on how to keep it a double column graph with 2 axis?