PC Review


Reply
Thread Tools Rate Thread

Bar Chart To Line Chart for last 3 points only

 
 
Big H
Guest
Posts: n/a
 
      13th Oct 2005
Hi There,

hopefully someone knows the answer, i have a simple chart going from january
to December. The chart info is actuals for January through to September
which are shown as a bar graph, what i want to do is create a line graph
showing the forecast for October through to December. Rather than creating a
new row of forecast data. Is it possible for me to insert the forecast
numbers in the actuals series and change the bar chart to a line for these
three months only. i.e January to September Bar Graph and October to
December line graph.

thanks Big H


 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      13th Oct 2005
I'm afraid not. I believe you'll have to create another series for the line
graph.

"Big H" wrote:

> Hi There,
>
> hopefully someone knows the answer, i have a simple chart going from january
> to December. The chart info is actuals for January through to September
> which are shown as a bar graph, what i want to do is create a line graph
> showing the forecast for October through to December. Rather than creating a
> new row of forecast data. Is it possible for me to insert the forecast
> numbers in the actuals series and change the bar chart to a line for these
> three months only. i.e January to September Bar Graph and October to
> December line graph.
>
> thanks Big H
>
>
>

 
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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Points on Line Chart Douglas Carr Microsoft Excel Charting 1 29th Jan 2010 07:34 PM
I need to hide points on a line chart if the value is ZERO =?Utf-8?B?UmFscGggRCcnQW5kcmVh?= Microsoft Excel Charting 4 9th Oct 2007 03:16 PM
Re: Line Chart with 400 Data Points Andy Pope Microsoft Powerpoint 5 23rd Dec 2006 02:12 PM
Accessing Points in a Line Chart Techno_Dex Microsoft Excel Charting 3 12th Aug 2006 12:00 AM
Line chart with two series; how to add points to one and not the other? chowgirl Microsoft Excel Charting 0 8th Feb 2006 09:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:02 AM.