Thread: sales chart
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek Dandy Derek Dandy is offline
external usenet poster
 
Posts: 2
Default sales chart

This is where I get stuck.
When I
add the secondary axis, Excel puts the bar for the sum above the first
department. Any help you can provide would be appreciated



"Bernard Liengme" wrote:

Columns on two axes (secondary axis bar chart)
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Derek Dandy" wrote in message
...
I am trying to graph my stores department sales for three years. X- axis
will be each department with three bars above it (2004, 2005, 2006). I
get
this far. Next I am trying to use a second y-axis on the right to graph
the
sum of the department sales for each year. This is where I get stuck.
When I
add the secondary axis, Excel puts the bar for the sum above the first
department. Any help you can provide would be appreciated