 |
 | 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 / October 2006Charting Time formats
I am trying to chart some times in a bar chart the first column lists 3 queue types in a benefit office to be used as the legend. The second column has a times listed against the 3 queues formatted into hours and minutes. When I try to create a bar chart based on this simple data, the chart wizard does not pick up the data of the series so shows a blank chart. Any ideas? I wonder what your data actually looks like. Would you care to post a sample? Just copy it and paste it into a reply. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ >I am trying to chart some times in a bar chart the first column lists 3 >queue [quoted text clipped - 6 lines] > > Any ideas? Jon, the format was Excel 2000. Here is part of the table of data. Contact Area Tickets Taken Walkaways Customers Dealt with Queries Dealt with Longest Serving Time Queue 1 Benefits 559 33 526 550 0:52:00 Queue 2 Council Tax 332 46 286 308 0:38:00 Queue 3 Housing 798 171 627 627 2:11:00 Totals 1689 250 1439 1485 I wanted to be able highlight just the first column (Contact Area) and then the last column (Longest Serving Time) to show a bar chart as comparison. I have recreated the data in a new sheet and it worked so I am thinking the data maybe corrupt in this sheet (inherited from another dept). Any thoughts you may have gratefully received. > I wonder what your data actually looks like. Would you care to post a > sample? Just copy it and paste it into a reply. [quoted text clipped - 16 lines] > > > > Any ideas? The data as you pasted and I copied is fine. But to ensure the proper data is selected, delete the contents of the top left cell. Suppose the data is in A1:F5, clear cell A1. Now select A1:A4 (yes, including the blank cell), hold CTRL while selecting F1:F4, and use the chart wizard to make your chart. The blank cell helps Excel to parse the data, by showing that the top row (series names) and first column (categories) are different from the rest. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Jon, the format was Excel 2000. Here is part of the table of data. > [quoted text clipped - 37 lines] >> > >> > Any ideas? Jon Many thanks for your response which I followed to the t but I could not get the Chart Wizard to pick up the data for the time column (Longest Time) it just presents a blank sheet. Am I missing something? Any ideas gratefully received. > The data as you pasted and I copied is fine. But to ensure the proper data > is selected, delete the contents of the top left cell. Suppose the data is [quoted text clipped - 52 lines] > >> > > >> > Any ideas? |
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
|
©2009 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.