What is this series1, sires 2....etc in charting

		Excel Help Forum > Usenet Groups > Excel Charting
What is this series1, sires 2....etc in charting

Notices

Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Thread Tools

Search this Thread

Rate Thread

Display Modes

09-08-2008, 04:14 AM

ramaswamyrmm ramaswamyrmm is offline

Registered User

Join Date: 28 Dec 2007

Posts: 7

What is this series1, sires 2....etc in charting

when i try to create a chart with datas from 3 columns,

1)the ledgen in the chart shows series 1 and series 2 - what is this ?

2)out of the 3 columns selected one is the date which is on the x axis,the other two columns are plotted, but the label appears only for one of them, is it possible to have two diffrent labels on either y axis

09-08-2008, 05:00 AM

Andy Pope Andy Pope is offline

Forum Moderator

Join Date: 10 May 2004

Location: Essex, UK

Posts: 2,141

Andy Pope will become famous soon enough

Series 1, Series 2 etc are the default names given to a series.
You can provide you own names either from cells or by directly changing the series formula.

Can you post the workbook and chart you have created.
Which range was selected when you created the chart?

__________________
Cheers
Andy

09-08-2008, 08:05 AM

ramaswamyrmm ramaswamyrmm is offline

Registered User

Join Date: 28 Dec 2007

Posts: 7

Explaination for sires 1,sires 2 etc

Thanks for both the responses ANDY.
I am attaching the excel sheet where I have the char at the end of the excel sheet. Thanks for the trouble.

Attached Files

punj lloyd to excl forum.xls (25.5 KB, 2 views)

09-08-2008, 08:17 AM

Andy Pope Andy Pope is offline

Forum Moderator

Join Date: 10 May 2004

Location: Essex, UK

Posts: 2,141

I have linked the series name to cells I3 and J3
Also added a duplicate series based on column I that has been moved to the secondary axis.

Attached Files

654935.xls (28.0 KB, 4 views)

__________________
Cheers
Andy

Bookmarks

New topics in Excel Charting

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	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 Off HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Charting Negative with Bar Charts	gacollege	Excel Charting	2	08-08-2008 03:22 PM
Trying to do dynamic charting.	gshock	Excel Charting	10	04-24-2008 10:28 AM
charting time for an entire month	uglygreencouch	Excel Charting	0	11-12-2007 12:10 PM
VBA of charting last months dynamically	tink_	Excel Programming	1	07-12-2007 03:07 AM
Live Charting	Rikuk	Excel Charting	1	05-16-2007 09:26 AM

All times are GMT -4. The time now is 07:33 PM.