Chart Wizard

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
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
How can I get my chart to look like this? Image included! 4
Chart Wizard 5
Accentuate diference between two values 3
Pie Chart 1
Charting Date Ranges 1
May you help me? output data MS Access query to excel and create chart. 2
Trendlines in a column chart not showing 1

Top