+ Reply to Thread
Results 1 to 4 of 4

I need both products price in 1 graph in excel chart

  1. #1
    Registered User
    Join Date
    03-01-2017
    Location
    france
    MS-Off Ver
    2010
    Posts
    10

    I need both products price in 1 graph in excel chart

    Hi i have 2 tables of different product in both tables common factor is price and year but product type is different can you please support to create this in 1 graph i can do this in 2 graphs but i want both products in 1 graph.

    Let say 1 product tv screen size average annual price 5 years(2016 to 2020) from 18'' 21" 24" 30"

    2nd product car type as per speed 100mph 120 mph 125mph 150mph annual average price for 5 years (2016 to 2020)

    I need both products price comparison in 1 graph in excel chart.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by qureshi2016; 04-17-2021 at 03:31 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: I need both products price in 1 graph in excel chart

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: I need both products price in 1 graph in excel chart

    It's not clear to me what you want to show in this chart. As a first guess:

    1) Select B5:B13 ctrl D5:D13 -> Insert XY scatter chart
    2) Bring up the Select Data dialog -> Add data series -> Select G5:G13 for the X values and I5:I13 for the Y values.
    3) Any formatting for chart elements that you want.

    Did I correctly guess the data you wanted included in the chart? What do you like about that chart? What do you dislike?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: I need both products price in 1 graph in excel chart

    Looking at your file again, I see the problem. All of your numbers appear to be numbers stored as text with a trailing non-breaking space (unicode 160) character. You will need a strategy (like this one: https://www.xelplus.com/excel-trim-all-spaces/ ) that will convert your numbers with trailing spaces stored as text to actual numbers.

+ 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. Chart/Graph showing volume and price variances by region
    By adamski911 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-08-2019, 12:43 AM
  2. [SOLVED] Formula for increasing the price of certain products
    By rabbycrabby in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-25-2015, 03:04 PM
  3. Making price chart for 3 products in 3 companies
    By Bandini in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-09-2014, 03:17 AM
  4. How many unique products in a price band
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-09-2013, 10:59 AM
  5. Need Help Getting Price to Autofill For a products with three price options
    By elkhntr4 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-13-2012, 10:41 AM
  6. How to add up products across a row based on a price list?
    By JonathanSQ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2008, 01:30 PM
  7. [SOLVED] calculate % change in price for each of 200+ products
    By Jeff in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 03:10 AM

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