Y Axis - Horizontal Bar Graph
 

Hi, I need to produce a horizontal bar graph from the following set of data:

Quarter Q1 04 Q2 04 Q3 04 Q4 04 Q1 05 Q2 05 Q3 05 Q4 05 Q1 06
Jul Q1 Actual 38,221 45,749
Jul Q1 Forecast 12,777 55,829 16,257 4,016 214 0
Oct Q2 Actual 38,221 45,749
Oct Q2 Forecast 12,777 55,829 16,257 4,016 214 219
Jan Q3 Actual 22,539 45,749
Jan Q3 Forecast 12,777 55,829 16,257 4,016 214 219 465
Apr Q4 Actual 99
Apr Q4 Forecast 12,777 55,829 16,257 4,016 214 219 465 319


I have added a secondary Y axis but it shows the $ value instead of the time
scale (Q1 04, Q2 04 etc) .

How can I get the graph to show the Q1/Q2/Q3 on the primary Y Axis?

Eagle -

I can't figure out what you're plotting, or how. What are the series, what are the
categories?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Eagle wrote:

Hi, I need to produce a horizontal bar graph from the following set of data:

Quarter Q1 04 Q2 04 Q3 04 Q4 04 Q1 05 Q2 05 Q3 05 Q4 05 Q1 06
Jul Q1 Actual 38,221 45,749
Jul Q1 Forecast 12,777 55,829 16,257 4,016 214 0
Oct Q2 Actual 38,221 45,749
Oct Q2 Forecast 12,777 55,829 16,257 4,016 214 219
Jan Q3 Actual 22,539 45,749
Jan Q3 Forecast 12,777 55,829 16,257 4,016 214 219 465
Apr Q4 Actual 99
Apr Q4 Forecast 12,777 55,829 16,257 4,016 214 219 465 319


I have added a secondary Y axis but it shows the $ value instead of the time
scale (Q1 04, Q2 04 etc) .

How can I get the graph to show the Q1/Q2/Q3 on the primary Y Axis?