+ Reply to Thread
Results 1 to 9 of 9

Required chart for display monthwise total sales & market share

  1. #1
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2019
    Posts
    160

    Required chart for display monthwise total sales & market share

    Dear All,

    enclosed herewith a brandwise segment wise month wise brandwise sales sheet.
    i want a column chart for Display Brandwise Sales of Selected Customer & Selected Month & Selected Segement Wise Sale using VBA or Pivot or slicer if any.

    It will work even if it is not done by the vba code.

    also i attached a sample pic.

    chart.png

    Thank you All.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Required chart for display monthwise total sales & market share

    As you are using the 2016 version of Excel you could employ Get & Transform to help.
    1. Convert the range of data on Sheet1 into a table
    2. Use the following Power Query advanced editor code to produce a row over row (proper) data set as modeled in columns A: on Sheet 2
    Please Login or Register  to view this content.
    The new table is then used to produce a pivot table with slicers and a pivot chart.
    Column T is populated using: =IFERROR(GETPIVOTDATA("Sum of Sales",$I$3,"BRAND",I4),"")
    The sum of column T is displayed above the pivot chart.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2019
    Posts
    160

    Re: Required chart for display monthwise total sales & market share

    Sir, i dont know about power query, the chart is working correct but when i add new slicer for selection customer slicer after not working correctly also error found in my pc for internate explore upgrade So maybe not working correctly..

    thank you very much sir.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Required chart for display monthwise total sales & market share

    Assuming that Party Name in the data represents the 'customer', here is another copy of the file with the 'customer' slicer added.
    Let us know if you have any questions.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2019
    Posts
    160

    Re: Required chart for display monthwise total sales & market share

    JeteMc Sir, Working 100% Perfectly ,

    Thank you very much ,Sir :

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Required chart for display monthwise total sales & market share

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

  7. #7
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2019
    Posts
    160

    Re: Required chart for display monthwise total sales & market share

    Sir, in the thread tools menu no display 'Solved' option.
    display only 4 options
    1-Show Printable Version
    2-Email this page
    3-Unsubscribe from this thread
    4-all a poll to this Thread
    which option i select sir ?

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Required chart for display monthwise total sales & market share

    Menu options must have been changed, however Thank You for making the attempt. I hope that you have a blessed day.

  9. #9
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2019
    Posts
    160

    Re: Required chart for display monthwise total sales & market share

    Sir, Done

+ 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. Help adding market share line over bar chart
    By Character_Zer0 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2014, 04:40 PM
  2. [SOLVED] Time Series Forecast based on market share (market penetration)
    By mils in forum Excel General
    Replies: 5
    Last Post: 02-17-2014, 09:40 AM
  3. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  4. How to calculate market growth and market share?
    By keesberbee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 02:42 AM
  5. Market Share
    By seikho in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-31-2012, 05:27 PM
  6. [SOLVED] Share of Excel in the market
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 05-12-2006, 07:50 AM
  7. calculation sales monthwise
    By Rao Ratan Singh in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-01-2006, 08:35 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