+ Reply to Thread
Results 1 to 2 of 2

help creating a graph

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    Washington
    MS-Off Ver
    2013
    Posts
    5

    help creating a graph

    id like to compare the items in the tables from year to year (2018 vs 2019). i'm having a hard time finding a way to create this graph. any help is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,453

    Re: help creating a graph

    Your sample file does not contain any charts or any indication of what data you are trying to show on a chart. I also cannot tell what kind of chart you want to use.

    I find that a lot of chart questions are often about arranging data in the spreadsheet. I find that it is easiest to create a chart when my category x axis data are in a contiguous range (usually in a column), with adjacent ranges (columns) containing the desired series Y value data. This help file (https://support.office.com/en-us/art...3-b3fd5d5680c2 ) with a basic overview of how to create charts, has several examples of how to arrange data in the spreadsheet. To create a chart from your data, I would expect to:
    1) Identify the desired X (Year???) and Y values (???). If needed move/copy/link to data in existing tables to get the data table that the chart will need.
    1a) Don't forget that sometimes the easiest way to do this for "database summary" type data is to make sure the raw data are in a good database arrangement and then use a pivot table to get the summary data.
    2) Select the chart data and insert the desired chart type.
    3) Format chart as desired.

    Most of the work is in step 1, where most of what you want is least understood. How can we help you get the data you want for your chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  2. Creating Graph with VBA
    By ajc5382 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2012, 09:16 PM
  3. Creating a Graph
    By oliver79 in forum Excel Charting & Pivots
    Replies: 22
    Last Post: 12-22-2009, 10:17 AM
  4. Creating a bar graph
    By ahazin in forum Excel General
    Replies: 4
    Last Post: 04-19-2009, 09:07 PM
  5. [SOLVED] Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 AM
  6. creating a graph - help
    By educator in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-04-2005, 06:10 PM
  7. Creating a graph
    By JF in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2005, 09:05 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