View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jonathan Jonathan is offline
external usenet poster
 
Posts: 138
Default Creating a graph similar to a stacked column graph

Thank you for replying. What we need is for the data to be plotted in the
same "column". For example, lets say we are comparing July 2005 'repeat' and
'new' sales to July 2006 'repeat' and 'new' sales. I want to show only two
columns, one for July 2005 and one for July 2006. Within each of the two
columns would be the 'repeat' sales amount and layered on top of that would
be the 'new' sales amount. The columns would be only as high as the total
sales for that month. Thank you again and I look forward to hearing back.

"Jon Peltier" wrote:

Do you want a clustered column chart? The data won't be plotted in the same
"column", but the columns will be over the same category.

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


"Jonathan" wrote in message
...
I am trying to create a graph that will show new sales vs repeat sales in
one
column, but I do not want the data to be stacked. In doing so I will be
able
to see how much greater one is over the other. Thank you in advance.
This
will be a great help to me and my department.