+ Reply to Thread
Results 1 to 3 of 3

Comparison price (national and world price) in one graph

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    166

    Comparison price (national and world price) in one graph

    Hey community.
    I would like to show in one graph the competitive average price of category of item from France but also the the competitive average price of category of item from World.
    I put the worksheet "Template". I've create two pivot tables on the sheet "ND-France",

    Capture.PNG


    Thank your for your help.
    Attached Files Attached Files
    Last edited by Luu4466; 11-22-2020 at 02:41 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: Comparison price (national and world price) in one graph

    Hi,

    See attached.

    I added three helper columns to your data
    In column L I first had to use =TRIM() since some categories had leading spaces in some countries
    I also had to change "Recheargeable Battery" to "Rechargeable Batter" and "Wireless M" to Wireless Mic" in some cases
    Attached Files Attached Files
    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 Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    166

    Re: Comparison price (national and world price) in one graph

    Excellent! Thank you very much Richard Buttrey! So smart to use the formula "IF" to put data for World in the sheet " Raw Data inputs"

+ 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. Price Comparison Formula
    By zainmerchant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2020, 06:51 PM
  2. [SOLVED] Price Comparison for a Product
    By chandramouliarun in forum Excel General
    Replies: 5
    Last Post: 06-28-2019, 01:03 AM
  3. Price comparison (+ or -) formula
    By mlopez60120 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2016, 04:56 PM
  4. Competitors Price Comparison Other Methods they May Use
    By ryanb4614 in forum Excel General
    Replies: 3
    Last Post: 04-16-2015, 07:47 PM
  5. How to automate weekly price updates from diff. suppliers into 1 price comparison sheet
    By blindside21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2014, 02:24 PM
  6. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  7. Replies: 4
    Last Post: 08-15-2012, 09:49 AM

Tags for this Thread

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