[mso] Re: Excel Charts
- From: "Andrew Kendon" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 27 Aug 2005 08:05:13 +0100
I believe that you posted this question a while back. It's possible that
you didn't get a reply because the question is rather a general one.
The answer is Yes, it is possible. How you do it depends on:
1) How you want the 2004 data to appear on the chart
a) as a backward extension of the 2005 data
b) as a new series alongside the 2005 data (for comparison)
2) Where your 2004 data is
a) in the same worksheet as the 2005 data and contiguous
with it
b) in a separate worksheet or even a separate workbook
To modify the range of data and the series displayed in a chart, right-click
the chart area and select Source Data. Here you can change the Data Range
and add new Series, depending on what you need to do. If your 2004 data is
in a separate workbook, you would find it convenient to copy it or link it
into the same workbook as the 2005 data, either on a sheet of its own or
inserted above the 2005 data to make a continuous 2 year set of data.
You could also copy the 2005 chart to another sheet or another workbook and
change the Data Range and Series ranges to cover the 2004 data (but you
specified adding the 2004 data to the 2005 chart).
I hope that gives you pointers on the way to go
Andrew
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of beaton5284
> Sent: 26 August 2005 20:37
> To: mso
> Subject: [mso] Excel Charts
>
> Hi,
> I have constructed a chart from data on a sheet in Excel
> 2002. This data is for the year 2005. Is it possible to add
> data in the same chart format from the year 2004 to the 2005 chart?
>
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
