+ Reply to Thread
Results 1 to 2 of 2

create chart from imported data

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    Petaluma, CA
    MS-Off Ver
    2016
    Posts
    3

    create chart from imported data

    I don't want to "re-invent the wheel", so anyone know of a template for home energy tracking?
    Monthly source data includes DATE, START TIME, END TIME, and USAGE.
    I'd like to have 2 charts: An HOURLY column chart (by hour for all 24 hours) for a selectable day and a DAILY column chart indicating the total usage for each day of the month. It would be a plus if hovering over a specific column would should the exact amount from the source data.

    I've include a data sample as an attachment.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,921

    Re: create chart from imported data

    To get a chart from the data select one of the cells in the range A1:D9 > press Alt + n + c for a column chart or Alt + n + r for recommended charts.
    I feel that a pivot table and chart will offer the ability to select days and months although in order to help produce a chart that is selectable by day we would need to see at least two days worth of data and we would need a month's worth of data to help produce a daily column chart for a month.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-30-2020, 07:00 AM
  2. Created a chart out of imported data from MS Project
    By debruyne in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2012, 06:20 PM
  3. add imported text file name above imported data
    By tompie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2009, 08:18 AM
  4. Determine create date of imported file
    By ST4RCUTTER in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2007, 03:18 PM
  5. can't make a chart from data imported from txt file
    By bratek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2006, 09:50 AM
  6. Chart data file lost - need to re-create from chart?
    By LostExcelData in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2006, 03:00 PM
  7. Replies: 0
    Last Post: 05-19-2006, 02:25 PM

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