+ Reply to Thread
Results 1 to 2 of 2

Best Chart to fit the Pricing data across Industries and Pricing Tiers for Different Years

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Best Chart to fit the Pricing data across Industries and Pricing Tiers for Different Years

    Hi All,

    I have the following data...Wondering what would be the best charting approach for the same.. Attached the data in the excel sheet...

    Industry Pricing Tier Existing Revenue-2020 pricing scenario-1 Revenue pricing scenario-2 Revenue
    Financial Services B 20055 23286 27576
    Financial Services C 157775 201322 225861
    Financial Services D 513400 596863 617712
    Financial Services E 1309151 1634011 1629132
    Financial Services F 2820714 3103097 2960224
    Government B 2147 3435 3560
    Government C 143753 168409 158964
    Government D 864679 1093644 990123
    Government E 1939183 2350121 2040277
    Government F 3139912 3625657 3026749
    Talent Solutions B 50770 55878 48902
    Talent Solutions C 96430 115115 96860
    Talent Solutions D 348734 412423 328706
    Talent Solutions E 1231292 1430483 1056894
    Talent Solutions F 2028855 2169793 1551981
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Best Chart to fit the Pricing data across Industries and Pricing Tiers for Different Y

    Perhaps a clustered column chart.

    I put the data into a pivot table then created a pivot chart with slicers to filter the data.

    See attached.
    Attached Files Attached Files

+ 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] Formula to calculate pricing with graduated, cumulative tier pricing
    By laeyag in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-12-2021, 04:42 AM
  2. Formula for Tiered pricing with various pricing matrix
    By kunaltalreja in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2020, 11:37 AM
  3. I need help creating a formula to pull back data and pricing based on tiers
    By bbeards2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2015, 01:36 PM
  4. [SOLVED] Trying to compare current pricing and costs with suggested pricing
    By dearnne in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 07:01 PM
  5. Pricing Guide/Chart with variable pricing increases
    By HSDesigns in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-23-2013, 04:49 PM
  6. [SOLVED] Calculate Pricing from Start and End Date with different Pricing Weight for Each month
    By xyang06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 02:54 AM
  7. [SOLVED] Pricing Grid for t-shirt pricing
    By theprint in forum Excel General
    Replies: 5
    Last Post: 03-19-2012, 12:20 PM

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