Home |
Search |
Today's Posts |
#1
|
|||
|
|||
having trouble creating chart to show monthly totals
Hi
I'm using office XP. I keep a single spreadsheet were I record orders received. Its a very simple sheet with one order per row. In col B I place the date the order was received (in the format DD/MM/YY) I'd like to make a chart (pie or column) which displays the total number of orders per month so that I can see at a glance when were busy and quieter periods. I've tried using the wizard but all I ever get is a mess and not what I expect to see at all. I suspect I may need to separate my data by month? But is there a way for Excel to work that out for itself from a single column of dates? Maybe I'm expecting far too much or I haven't laid out my data correctly. I'm assuming Excel can distinguish the dates by month and then calculate the total number of orders received within each month. Your guidance would be much appreciated. Many thanks for your time. Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Creating a High-Low-Close chart with multiple series? | Excel Discussion (Misc queries) | |||
creating a chart | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel | |||
creating an x,y chart | Charts and Charting in Excel |