Multiple data in series
I am trying to put multiple date in a series on an Excel chart (Excel 2000). I have two values that I want to show in one month. I want the series to have seperate colors by value but totaled for the month. For example, in June 2005, there is $200 in sales of cookies and $200 in sales of candy. I want to show $400 in sales, but show the series as $200 (green) indicating cookies and $200 (yellow) indicating candy. -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
Hi Anne- I think this is what your after: a stacked column graph. put the data in table format: Month $Cookies $Candy Select the whole table and make a chart (either click the chart icon, or select chart from the insert menu) This will start the chart wizard, choose column as chart type and stacked column (top row, second from the left) as the sub type. The wizard will walk you through the rest. Good luck, pim -- Pim ------------------------------------------------------------------------ Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
What I have is data for January through Decemer for the years 2002 - 2005. Now I need to start seperating data for each month in two catagories. I don't even know if it is possible to have a stacked column chart. I need a chart that shows at the bottom each month grouped together with a series for each year. Then starting in June of 2005, showing two values in one series stacked. Like all this time until June 2005 we were counting cookies and candy as sales together but now we want to show in the single series stacked the total of cookies and candy. :eek: -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
Did you try Pim's suggestion?
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ann Kelley wrote: What I have is data for January through Decemer for the years 2002 - 2005. Now I need to start seperating data for each month in two catagories. I don't even know if it is possible to have a stacked column chart. I need a chart that shows at the bottom each month grouped together with a series for each year. Then starting in June of 2005, showing two values in one series stacked. Like all this time until June 2005 we were counting cookies and candy as sales together but now we want to show in the single series stacked the total of cookies and candy. :eek: |
Hi Ann hm... well, try this as an example and see if it looks right- if not, indicate what's off and we'll go from the (that way you don't have to go through the pain of formatting your data- then finding out this isn't quite right) type in into an new sheet: cell a1:Month B1: Total Cookies C1:Total Candy A2: June B2:500 C2: 750 A3: July B3: 250 C3: 350 A4: August B4: 450 C4: 500 highlight the cells in A1:C4 and start the chart wizard- and take it from the first post. If you're looking for an easy way to separate the data, that's a whole new ball game ;) -- Pim ------------------------------------------------------------------------ Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
I did try Pim's suggestion. Pim, your last entry I tried and it worked although I have too much data for the graph to look right. On the left column, the data is months. At the top I have years 2002-2005. In June 2005, my supervisor decided that we need to split out the data and he wants to show the data in the same column for that month but show it in different "colors" indicating the split data. He still wants the graph to show the years 2002-2005. I guess I am coming to think that there is no way to have a stacked graph that will show the data the way it will look presentable. Thanks for your help! :) -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
What is good about Pim's suggestion and bad about its use with your data? Why does
"too much data" make the chart not look right? How do you need to change its formatting to make it presentable? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ann Kelley wrote: I did try Pim's suggestion. Pim, your last entry I tried and it worked although I have too much data for the graph to look right. On the left column, the data is months. At the top I have years 2002-2005. In June 2005, my supervisor decided that we need to split out the data and he wants to show the data in the same column for that month but show it in different "colors" indicating the split data. He still wants the graph to show the years 2002-2005. I guess I am coming to think that there is no way to have a stacked graph that will show the data the way it will look presentable. Thanks for your help! :) |
What was good about Pim's suggestion was I was able to show the data for June 2005 stacked. My original chart has the labels at the bottom for just the month and they are grouped. So the first group is January and there are 4 bars showing each year under that label. The next label is February and so on. When I changed the graph to Pim's suggestion, the months are no longer grouped. Each column shows the data label as "Jan-02", "Jan-03", etc. I want the chart to look like my original chart showing the groups with individual columns for the year and to start stacking the figures for each month (2 different values). Thanks, Ann :rolleyes: -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
I'm having a little trouble visualizing this (sorry, it's getting late). Perhaps it
would help if you included a sample of your data, so we can see how it's arranged, then explain to us what's clustered and what's stacked. (Make sure you type slowly, so we can keep up!) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ann Kelley wrote: What was good about Pim's suggestion was I was able to show the data for June 2005 stacked. My original chart has the labels at the bottom for just the month and they are grouped. So the first group is January and there are 4 bars showing each year under that label. The next label is February and so on. When I changed the graph to Pim's suggestion, the months are no longer grouped. Each column shows the data label as "Jan-02", "Jan-03", etc. I want the chart to look like my original chart showing the groups with individual columns for the year and to start stacking the figures for each month (2 different values). Thanks, Ann :rolleyes: |
I just added my excel spreadsheet. -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
Okay, I thought I uploaded the spreadsheet! Not sure where it went. -- Ann Kelley ------------------------------------------------------------------------ Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590 View this thread: http://www.excelforum.com/showthread...hreadid=471114 |
I just meant pasting some of the data into a reply. Some interfaces
strip out the attachments, and a lot of people don't open them anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ann Kelley wrote: Okay, I thought I uploaded the spreadsheet! Not sure where it went. |
All times are GMT +1. The time now is 08:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com