Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart to compare data
This is a basic question, but I'm new to charts. I have the following
information: Hours Billable Hours Worked 9/15 121 128 9/30 159 136 10/15 133 134 I would like to make a column chart to compare the data for each pay period. I would like the horizontal axis to list the dates. I would like each date range to encompass two columns (Hours billable & Hours worked) for that date. I would like to these two columns to be side by side touching. Then I would like a small space and the next date with the two columns corresponding to that date there. I have figured out how to make the basic graph with all the columns touching, but I would like to separate them out by date and I can't get the horizontal axis to list the dates out. Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart to compare data
Select all your data. Open the chart wizard, create a clustered column chart.
Once you have the chart created you may need to adjust the x-axis. If you only want the dates you listed to be displayed, right-click on chart, chart options. Go to the axis tab, and select "category" under the x-axis. If you want a time-scale axis (with all calendar dates) choose "time scale" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "BrookieOU" wrote: This is a basic question, but I'm new to charts. I have the following information: Hours Billable Hours Worked 9/15 121 128 9/30 159 136 10/15 133 134 I would like to make a column chart to compare the data for each pay period. I would like the horizontal axis to list the dates. I would like each date range to encompass two columns (Hours billable & Hours worked) for that date. I would like to these two columns to be side by side touching. Then I would like a small space and the next date with the two columns corresponding to that date there. I have figured out how to make the basic graph with all the columns touching, but I would like to separate them out by date and I can't get the horizontal axis to list the dates out. Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart to compare data
Probably a time-scale axis is not good here. The dates are weekly, so
there would be a six-day gap between each one day of data. The trick is to make sure there is a nonzero gap width, which is the distance between adjacent clusters of columns. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Luke M wrote: Select all your data. Open the chart wizard, create a clustered column chart. Once you have the chart created you may need to adjust the x-axis. If you only want the dates you listed to be displayed, right-click on chart, chart options. Go to the axis tab, and select "category" under the x-axis. If you want a time-scale axis (with all calendar dates) choose "time scale" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
bar chart to compare month and year data | Charts and Charting in Excel | |||
Want to compare data in two numeric column | Excel Worksheet Functions | |||
compare date to column data | Excel Worksheet Functions | |||
How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) |