 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008Column charts
I'm trying to create chart where columns are side by side by one of the columns is stacked. I utilized the information found in Column Chart with a difference but some information is missing. I was able to get the stacked column but the information for the second column is not there. What did I do wrong. Example: Jan Feb Mar Discharges 60 55 20 (Stacked info) FS 45 44 29 C&FC 6 12 9 Other 0 0 1 >I'm trying to create chart where columns are side by side by one of the >columns is stacked. I utilized the information found in Column Chart with a [quoted text clipped - 10 lines] >C&FC 6 12 9 >Other 0 0 1 Don't put your Discharges in the same Excel spreadsheet column as your stacked info, but put it in a column one cell to the left or right. Like this: Jan Feb Mar Discharges 60 55 20 (Stacked info) FS 45 44 29 C&FC 6 12 9 Other 0 0 1  SignatureDel Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. >>I'm trying to create chart where columns are side by side by one of the >>columns is stacked. I utilized the information found in Column Chart with a >>difference but some information is missing. I was able to get the stacked >>column but the information for the second column is not there. What did I do >>wrong. >Don't put your Discharges in the same Excel spreadsheet column as your >stacked info, but put it in a column one cell to the left or right. [quoted text clipped - 6 lines] > C&FC 6 12 9 > Other 0 0 1 If you're having problems reading the text, try it this way: Jan Jan Feb Feb Mar Mar Discharges 60 0 55 0 20 0 FS 0 45 0 44 0 29 C&FC 0 6 0 12 0 9 Other 0 0 0 0 0 1 It's just the same layout with a lot of extra zeroes and Month headings filled in, but it may solve your confusion. SignatureDel Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.