+ Reply to Thread
Results 1 to 3 of 3

Values in Chart need to multiply not sum

  1. #1
    Registered User
    Join Date
    06-12-2018
    Location
    Serbia
    MS-Off Ver
    2013
    Posts
    2

    Values in Chart need to multiply not sum

    I need values on my chart to show total value when they are multiplied and not summed. Is it possible? In my table those values do multiply but when I do this chart they are summed.
    slika1.png

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: Values in Chart need to multiply not sum

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!




    Explain what you are doing.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-12-2018
    Location
    Serbia
    MS-Off Ver
    2013
    Posts
    2

    Re: Values in Chart need to multiply not sum

    Table represents betting value that we got right on soccer matches. So we multiply them to see who got the biggest value at the end. So when I do chart I want for that chart to show those values as on picture but not
    to sum them but to multiply them.
    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. Replies: 15
    Last Post: 09-09-2015, 08:42 PM
  2. [SOLVED] Trying to multiply values in other cells by 0.5 while disregarding values of zero
    By ericpenkala in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-24-2015, 11:36 PM
  3. Multiply a series values 'on the fly' before presenting in chart.
    By luftgekühlt in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-05-2014, 02:35 AM
  4. Refer to 3 cells then a chart to add XYZ multiply X to cell G9
    By WDDD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2011, 04:23 AM
  5. Multiply values and sum together
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 10-06-2011, 12:35 PM
  6. Find values position in table between two values, multiply by adjacent value
    By bradfordstl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2011, 01:14 PM
  7. How to Chart multiply values on x axis
    By mswltd in forum Excel General
    Replies: 1
    Last Post: 09-27-2010, 11:15 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