+ Reply to Thread
Results 1 to 4 of 4

Why can't I create a nice looking chart from this data?

  1. #1
    Registered User
    Join Date
    05-17-2013
    Location
    U.S.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Why can't I create a nice looking chart from this data?

    The data below represents how many faxes were received on each of the indicated days. I can't for the life of me create a descent looking chart using this data! I've tried creating my own, and plugging in the data into chart templates. They always look unreadable.

    Can someone tell me how I can create a nice looking chart using the data below?

    -Thanks!


    Date n Faxes
    01/01, 12
    01/02, 227
    01/03, 213
    01/04, 242
    01/05, 16
    01/06, 28
    01/07, 281
    01/08, 294
    01/09, 223
    01/10, 253
    01/11, 208
    01/12, 24
    01/13, 18
    01/14, 277
    01/15, 281
    01/16, 209
    01/17, 240
    01/18, 212
    01/19, 19
    01/20, 30
    01/21, 198
    01/22, 276
    01/23, 226
    01/24, 256
    01/25, 215
    01/26, 23
    01/27, 85
    01/28, 327
    01/29, 253
    01/30, 220
    01/31, 267
    02/01, 243
    02/02, 16
    02/03, 24
    02/04, 280
    02/05, 248
    02/06, 248
    02/07, 228
    02/08, 194
    02/09, 28
    02/10, 18
    02/11, 311
    02/12, 263
    02/13, 228
    02/14, 267
    02/15, 256
    02/16, 17
    02/17, 34
    02/18, 97
    02/19, 285
    02/20, 255
    02/21, 289
    02/22, 229
    02/23, 34
    02/24, 36
    02/25, 303
    02/26, 262
    02/27, 304
    02/28, 268
    03/01, 262
    03/02, 16
    03/03, 31
    03/04, 320
    03/05, 251
    03/06, 237
    03/07, 331
    03/08, 265
    03/09, 27
    03/10, 30
    03/11, 301
    03/12, 308
    03/13, 328
    03/14, 301
    03/15, 282
    03/16, 31
    03/17, 34
    03/18, 334
    03/19, 318
    03/20, 285
    03/21, 251
    03/22, 240
    03/23, 21
    03/24, 30
    03/25, 333
    03/26, 299
    03/27, 249
    03/28, 312
    03/29, 107
    03/30, 29
    03/31, 15
    04/01, 324
    04/02, 268
    04/03, 278
    04/04, 287
    04/05, 264
    04/06, 33
    04/07, 24
    04/08, 294
    04/09, 278
    04/10, 285
    04/11, 301
    04/12, 279
    04/13, 30
    04/14, 35
    04/15, 369
    04/16, 349

  2. #2
    Registered User
    Join Date
    05-11-2013
    Location
    Shrewsbury
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Why can't I create a nice looking chart from this data?

    Try this.
    Attached Files Attached Files

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Why can't I create a nice looking chart from this data?

    In the future please post a sample sheet instead of pasting a huge range. It clutters the thread and makes it hard to read

  4. #4
    Registered User
    Join Date
    05-17-2013
    Location
    U.S.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Why can't I create a nice looking chart from this data?

    Quote Originally Posted by yesitskez View Post
    Try this.
    Close! But for some reason all of the dates on the X axis are 1-Jan. Also, the data lines are not displayed on 3/4 of the graph. I've uploaded a copy at the URL below. Is that what yours looks like?

    -Thanks


    http://www1.datafilehost.com/d/7884a013

+ Reply to Thread

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