ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting
Charts within Charts Charts within Charts
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

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!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 09-06-2008, 10:47 PM
HSEGuy HSEGuy is offline
Registered User
  
Join Date: 06 Sep 2008
Location: Brisbane
Posts: 1
HSEGuy is on a distinguished road
Charts within Charts
Hi Everyone,

I have to chart safety statistics for my company and currently do using a simple 12 month rolling column chart. My boss has recently asked if the bar chart could begin with columns showing the averages of previously completed FY and then rolling into the current years month by month stats. I'm assuming I'd have to source the data for these average results separate from the current monthly performances but can't seem to figure out if I can split the source data in a single chart, or if excel can manage this?

My X-Axis Series should look like

FY2005/6,FY2006/7,FY2007/8, Jul 08, Aug 08, Sep 08.

Any help would be much appreciated!
Reply With Quote
  #2  
Old 09-07-2008, 07:21 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
  
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,303
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
Simplest way would be to use 2 series for the 2 data sets.
These can share the x-axis categories.
Attached Files
File Type: xls 654881.xls (25.5 KB, 7 views)
__________________
Cheers
Andy
Reply With Quote
Reply

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
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear 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
Charts that call data from a variable number of workbooks? Schwavan Excel Worksheet Functions 0 06-11-2008 01:31 PM
Rearranging many charts at once kapiszon2929 Excel Programming 2 03-06-2008 06:33 PM
Charts making file size big kingdt Excel General 1 09-28-2007 07:34 AM
automatically update charts slimjen Excel Charting 3 09-04-2007 07:25 PM
Same Charts Different Months Soltisolti Excel Charting 5 12-20-2006 12:27 AM


All times are GMT -4. The time now is 04:30 PM.

Contact Us - ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0