PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Re: Chart

Reply

Re: Chart

 
Thread Tools Rate Thread
Old 24-09-2003, 01:46 PM   #1
dvt
Guest
 
Posts: n/a
Default Re: Chart


Sanj wrote:
> Hello,
>
> I have a following chart problem:
>
> Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
> Age 10 20 30 40 50 60 40 50 30 N/A N/A N/A
> Pops 20 30 40 50 60 70 40 45 89
>
> How can I create linechart so that POps data starts
> showing beginning from Apr. I tried doing it but it always
> takes Pops data starting January. Any tips will be highly
> appreciated.Thanks
> Sanj


I suggest an XY scatter chart rather than a line chart. Use the Month row
as your x-axis values in both series.

Dave
dvt at psu dot edu


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off