+ Reply to Thread
Results 1 to 3 of 3

Time Charting issue, please help

  1. #1
    Registered User
    Join Date
    03-22-2012
    Location
    Bangalore, IND
    MS-Off Ver
    EXCEL 2010, 2007
    Posts
    90

    Question Time Charting issue, please help

    Time charting.xlsxHi,

    I am really stuck up or not aware how to plot a time data with respective names , I want to plot B,D & E column to a chart .. thanks in advance...
    Vipin Oceans

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Time Charting issue, please help

    1) Highlighted data D2:E44
    2) Inserted "clustered column chart" on new page
    3) Right Click = > Select data
    3.1) Horizontal (Category) Axis Labels => Edit => C2:C44
    3.2) Series one => Edit => D1
    3.3) Series two => Edit => E1
    4) Select horizontal axis => right click => Format Axis (Axis options) => Interval between labels changed from "automatic" to "1"

    That's attached.

    (If you want points instead of columns, select whole chart, right click => change chart type => line chart with points, then remove the lines to leave only the points.)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Time Charting issue, please help

    Hi,
    May be a way with pivot table and pivot chart
    Click on the chart and you are able to filter by Date and Associate Name
    You can rearrange your chart with any field
    Hope this help
    Best regards
    Attached Files Attached Files

+ 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