View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart and text box issues

Arrange your data like this:

2006 2007
Jan
Feb
Mar
etc.

leave the top left cell blank, and fill in values below the year labels and
to the right of the month labels. Select the data, including the year and
month labels and the blank cell, and make a clustered column chart.

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


"cempire5" wrote in message
...
Couple of questions: 1st, I have a chart comparing returning traffic for
jan-sep for 2006 and 2007. I would like the month columns to be right
next
to each other. For example, Jan 2006 & 2007 right next to each other and
then a space and then Feb 2006 & 2007 right next to each other. Right now
there is a space between every single column.
2nd, I have used data labels to identify the # of returning traffic for
each
month for both 2006 & 2007. I have included a text box at the bottom of
the
chart to label the months Jan - Sep. however they don't line up with their
respective column. They may look perfect on print preview, but when I
print
they are out of line and if I move it then someone choosing to forgo
printing
and just look at the computer screen, will see it all messed up. Any
suggestions?