Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
I am trying to do a stacked column chart, but it's not working and I've tried
everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
I have just put up a file for you at:-
http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
That is perfect!!! Thank you sooo much. I can put the name as the chart
title. Thank you again! "trip_to_tokyo" wrote: I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart
No problemo. A pleasure!
"BrookieOU" wrote: That is perfect!!! Thank you sooo much. I can put the name as the chart title. Thank you again! "trip_to_tokyo" wrote: I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |