Results 1 to 7 of 7

bar chart measuring minutes (not clock time)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2004
    Posts
    108

    bar chart measuring minutes (not clock time)

    Hey guys,

    I am trying to format a bar chart to measure the monthly call duration. Data in excel looks like this:

    4:20
    10:34
    8:21

    etc. It has to keep this minutes:seconds look for the chart data labels...not be converted to minutes in decimal form.

    Which cell format will allow both the chart data labels and the Y axis labels to display that way? I've tried time formats and custom formats and nothing seems to work. They all either seem to want to convert it to an actual timestamp (11/1/10 4:20 AM) or change it to minutes in decimal form.

    Thanks...
    Last edited by kmfdm515; 11-17-2010 at 01:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1