Chart Wizard

  • Thread starter Thread starter brianc0428
  • Start date Start date
B

brianc0428

I have a spreadsheet that I need to create a chart for. I have added
new column and now I am not able to use the Chart Wizard. I need t
show a chart of The Total Met compared to total missed by analyst. I a
able to select just the Total missed (n195 o195) but not the Analyst
name and number. I have a coulmn in between. Which stops the chart fro
creating it like normal. Is there a way to do it that I am unaware of?
Thanks in advance

Attachment filename: 06072004 weekly.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58349
 
Brian -

You can select a discontiguous range, with the region to the left of the
intervening column and the region to the right. Select the first area,
then hold CTRL while you select the second. If the two areas are
consistent (same length, starting in the same row), the chart wizard
will be able to process the range.

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