represent

  1. S

    Graph with Bars (Ranges) & Lines

    Hello, How would I go about making a graph which plots a number of bars (representing ranges) and lines on the same graph as per below: I would like the lines (which represent the 5th and 95th percentiles of the ranges) to intersect the range as shown in the image. Any ideas?
  2. L

    Importing Word Content into Excel

    Hi all, I have hundreds of word documents. I would like to extract the contents from the word documents and add them into excel with each cell in a single representing a unique word document. For example, B1 would represent word doc 1 B2 would represent word doc 2 .... ... . B897 would...
  3. C

    Pivot different columns

    Ok, so I have pivot table in which I have 2 values I need to represent. One value I have to represent by months and represent SUM, and other should be just SUM. If I put values in pivot, I can in one click present SUM of both values. OR I can separate both values by month, putting month field in...
  4. A

    Having trouble making diagram

    Hello all, so I want to make a diagram, but would like it to be like spiderweb or something. It is interconnecting and comparing diagram. so example A1 b1 c1 d1 e1 1 7 4 5 2 2 8 10 11 3 3 3 A1 d1 4 6 B1 5 9 6 4...
  5. J

    Index and match help

    Hi all, Not sure how i represent the following number searches when adding to index and match formula <colgroup><col></colgroup><tbody> Under 2.0 2.01 - 2.25 2.26 - 2.50 2.51 - 2.75 2.76 - 3.0 3.01 - 3.50 3.51 - 4.0 4.01 - 5.0 5.01 - 6.0 6.01 + Thanks in advance </tbody>
  6. A

    Bubble Chart & Pie Chart combined

    Hello I have been asked to create a bubble chart but I need to have each bubble dislaying 2 pie pieces (for example one bubble that has a "pie piece" to represent 10% of the bubble. Does anyone know if this is possible? Thank you for your help
  7. S

    Can a Letter Represent a Value?

    Brand new to the forum and fairly new to Excel and my question is: Can I format a cell so when I place a letter it will represent a numerical value in a formula? Here's the scenario: I want to format a cell so when I type in the letter 'E' a multiplier of '1' is placed in a formula but the...
  8. A

    FIND & REPLACE rows of text in an Excel worksheet

    Here is my problem: I’m trying to create a macro to find & replace certainrows of text in an Excel worksheet. Example: <tbody> 5710 Electric in Pasture (CLAIM 100%) 0.00 Dr </tbody> Replace with: <tbody> 5710 Electric in Pasture...
  9. R

    Latitude/ Longitude Formatting

    Hi All - It's been a while - hope one of you can help. I have latitude & longitude information in a text string that I am trying to convert to decimal format. In cell A1 the Latitude value is 0434010N In cell B1 the Longitude value is 0792201W In both of the above; Characters 1 - 3 represent...
  10. M

    Help please assignment due tommorow !!!!! I really need the help i dont know anything.

    https://paste.pics/b10ffadd0ed8462a39d6bc8608bf6258
  11. L

    using 0 instead of # in custom number formatting

    Hi I just watched a video on youtube about number formatting. I took screen shot of all the codes he was using, please see below. He only used 0 instead of #. I thought that is good idea because with 0 you can represent both the number and the zeros while with # you would only represent number...
  12. H

    Dynamically change each bar color based on a variable

    Hi, I have a graph that one axis is volume (bar graph) and the other is premiums (line graph). I want to apply a shading to the bars (volume) to represent a mix of volumes coming from two different locations which will be held within excel. Any ideas?
  13. G

    To replace value o with na

    Please how can I represent value 0 in all my cells to NA without affecting my formula
  14. bencar

    Is this Chart Correct?

    I got a chart problem I think I found the solution for. Here the problem. Below is my chart as a solution. "Create a two axis (primary/secondary) graph. The primary axis should represent cars and the graph should be a line. The secondary axis should be bars and represent gallons." <tbody>...
  15. A

    chart presentation issue

    Hello friends I would like to explain you my requirement. I have a sheet with 15 employee and their monthly based information,As you can see in attached file a red box with a main heading with 2 sub columns have the information of trips + commission, now i would like to represent the sub...
  16. D

    Index Match to convert alphanumeric to pure numberic

    Hello, I am having a consistent #N/A error when I try to convert a Base36 alpha numeric string into a pure numeric string that represents where in the Base36 alphabet the digit represents. For example, for Base 36, the number 0 is 0, the letter F would represent 15 and W would represent 32. The...
  17. H

    Merging two columns if blank

    Hi, I've searched high and low for how to do this but I can't find anything. Apologies if this is simple/answered many times! Basically I have multiple columns and the data is a bit messy. What I need to do is shift all my data so that it fills up from the furthest most column. I've tried to...
  18. D

    New Project Idea (Pivot Table?)

    I'm about to start a new project, but before I begin, I need to know if my idea is doable. Let's say for example that I want to have 4 columns named "First", "Second", "Third", and "Fourth" (cells D4, I4, N4, and S4). I want to have 13 Row Headers that represent each month of the year, with...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top