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.
  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...

Some videos you may like

This Week's Hot Topics