LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
JaB JaB is offline
external usenet poster
 
Posts: 23
Default Line Charts Problem

Hi there

I am having problems selecting the data I wish to display in a line graph.

Basically, using the data below, I would like to display the dates across
the horizontal axes and values and percentages plotted on the vertical axes.
With the values for the two sets of data (hats & coats) plotted in the graph.

The problem Im having is that I cannot see how to select a range of source
data when the data is not displayed in imeditately adjacent cells. Any ideas?

w/c Silk
20/03/2006Hats 81.1%
Coats 1384
27/03/2006Hats 79.3%
Coats 2071
03/04/2006Hats 94.8%
Coats 1589
10/04/2006Hats 89.5%
Coats 1187
17/04/2006Hats 71.7%
Coats 1390
24/04/2006Hats 86.0%
Coats 1449
01/05/2006Hats 89.9%
Coats 1287

Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charts - Text Box Problem tpearo Charts and Charting in Excel 1 June 21st 06 04:14 PM
Hiding 0 values in line charts Teri Charts and Charting in Excel 4 February 22nd 05 12:40 PM
Bar and Line Charts Keith Charts and Charting in Excel 1 February 18th 05 09:39 PM
Plotting blank cells in line charts? doogie Charts and Charting in Excel 3 February 16th 05 05:06 PM
Problem drawing lines on charts Susan Lambert Charts and Charting in Excel 7 December 13th 04 08:29 AM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"