PC Review


Reply
Thread Tools Rate Thread

Changing a bar chart

 
 
Charles Woll
Guest
Posts: n/a
 
      5th Jun 2006
In a standard bar chart, with say 5 yrs of data, I wish to make the 2006 bar
a stacked bar with the lower part the ytd and the upper part of the bar the
estimated year end. Pls help.

--
\\\|///
\\ ~ ~ //
( @ @ )
--oOOo-(_)-oOOo---
Charlie Woll



 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      6th Jun 2006
You could enter the data in two rows, then create a stacked column chart
from all the data. For example:

2002 2003 2004 2005 2006
YTD 50 55 60 65 30
Est 40


Charles Woll wrote:
> In a standard bar chart, with say 5 yrs of data, I wish to make the 2006 bar
> a stacked bar with the lower part the ytd and the upper part of the bar the
> estimated year end. Pls help.
>



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
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
Changing chart name and sorting by chart name navin Microsoft Excel Programming 1 28th Mar 2007 06:38 PM
Changing chart title changes position of chart =?Utf-8?B?QmluZw==?= Microsoft Excel Programming 3 9th Mar 2005 08:11 AM
Changing to Combination-chart from existing chart Jan Microsoft Excel Misc 1 27th Jul 2004 12:18 PM
chart with changing data source interactive chart Feketik Microsoft Excel Charting 2 19th Mar 2004 09:26 AM
chart with changing data source interactive chart Feketik Microsoft Excel Charting 0 18th Mar 2004 04:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:09 PM.