+ Reply to Thread
Results 1 to 3 of 3

Trying to get all the data on one chart

  1. #1
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    152

    Trying to get all the data on one chart

    I am totally blanking on how to get all the data on one chart. I've attached a worksheet.

    Does anyone have any ideas? In my head I'm thinking of a line chart, I just can't figure out how to do it.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,410

    Re: Trying to get all the data on one chart

    Get you data in to block that is understood by the chart.

    You now probably need to describe what you actually want in the chart as it's very difficult to read with all those series in one chart all at once
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    152

    Re: Trying to get all the data on one chart

    Now that's a good idea! Thank you. I was thinking about diving it up by quarters instead of months.

+ 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. How to use Formula in Chart Filters > Edit Data > Chart Data Range
    By GregM56 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-04-2019, 05:27 PM
  2. Pivot Combo chart - retain chart type for specific data series
    By meileetan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-21-2019, 03:48 AM
  3. Replies: 3
    Last Post: 07-17-2018, 08:16 PM
  4. Replies: 2
    Last Post: 10-16-2014, 08:57 PM
  5. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  6. Chart with dynamic data in a row, account valid data only when building chart
    By artmak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2014, 02:21 PM
  7. Replies: 3
    Last Post: 03-23-2012, 05:44 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