1. W

    Defined coloring of dynamic diagrams

    Hi all, I would like to color the diagrams "Result" automatically according to the specified color. However, the diagrams should be based entirely on the arrays and adapt themselves completely dynamically. --> For example, if I add "Spain", Spain should also be added in the color green in all...
  2. Y

    Chart with VBA

    Hi Experts, I am trying to create an automated mind map chart according to the table. So basically group one would be on the left, if IN is true then group 2 "feeds" group 1, if OUT is true then group one feeds group 2, if both are true then they feed each other. Group 2 always feeds group 3...
  3. D

    Relationship Diagram in Excel or other Microsoft Tools

    Hello Experts, I am trying to create a complex relationship diagram in Excel or any other Microsoft Tool available. A short and simple version of data is below: Heading Money Link In Money Link Out Wire In Wire Out Savings Account Yes No Yes Yes Checking Account No Yes Yes No...
  4. M

    Colours to diagram-values

    Hi. I would like to make one single horizontal staple in a diagram which changes colour depending on the values in the connected column. Is this possible to program so that the colour changes if the value changes? Or does someone has a trick-solution?
  5. 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...
  6. mgirvin

    Expanded Table for Many To Many Relationship?

    Dear Team, I have a Data Model that contains a Many To Many Relationship and a Bridge Table. Here is the picture of my Data Model: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/01-DataModelWithBridgeTable.jpg I have started to create an Expanded Table Diagram. Here is the picture of my...
  7. Phil Smith

    How to cut and past range from one worksheet to another?

    My code keeps failing at this line and I am banging my head against a brick wall! :banghead: Sheets("Diagrams").Range(Cells(LastCR, 1), Cells(LastEnd, 6)).Cut Destination:=Sheets("New Diagram") For the first range to be cut, LastCR=6862 and LastEnd=6807. How do I cut this range to the...
  8. M

    what is a diagram in excel

    Hi There I received this file from someone, please see the screen shot below. What are these arrows, when i click on them, it opens up with a text box on left and it says its a diagram. how do you get this, is it done in excel or somewhere else like Visio and imported in excel. its not a...
  9. G

    VBA code for Fishbone diagram

    does anyone has a VBA code for creating fishbone diagram?
  10. W

    Line chart - percentage based on result on last row

    Hi gurus. I'm trying to create S-curve with two series of values. For the X-axis, however, I'd like to show data as a percentage of the series' last value. Idea is that both lines should end up 100% even though they have different end values. Any ideas how I can do that?
  11. B

    formula for finding drawings' latest revision

    Below is an extract from a drawing register spreadsheet & in column B, I require a formula that displays the latest revision of the document. Column E onwards display the received/issued revisions of the documents listed in column A at different times during the life of the project. As new...
  12. J

    Time Space Diagram for Signal Timing

    I am would like to create a time space diagram in excel so I can show how signal timing would work for vehicle and bike progression speed respectively. You can see below what I would like to be able to graph, not sure how to actually do this would be cool if someone could explain how.
  13. A

    Is this Venn possible?

    Hi, I have a question about creating a Venn diagram and want to know if it's even possible. The data I would want would be something like: Name - John English Speaker - Yes Disability - Yes Working - No What I would love to be able to do (and don't know if it's at all possible) is that a Venn...
  14. T

    Selecting shapes and images in specific range, grouping then pasting in a new worksheet retaining group status.

    Hi, I am trying to create a form that people can edit. Users will use various shapes and images in a range to create a diagram and I want to save it to a table in another worksheet. The code below almost does what I want except it pastes the group of shapes as a picture. I would like to be able...
  15. B

    One column diagram

    Hi! Have roughly 2200 times (hh:mm) which I need to plot in a diagram, as to how often a certain time appears. Help...
  16. K

    Formula that returns values to a scatterplot

    Hi, I have a series of values for a scatter plot. For some of the values I have created this formula to return values: =IF(LEFT(D43;4)="-N/A";"";D43) When a cell is -N/A the value for the scatter plot is blank but it doesn't work with with the diagram. All I can do now is to delete the formula...
  17. J

    arrow diagram

    i want to make a diagram/graph out of a given function. The diagram (dont know the enlish term) is made out of a line connecting the X axis and the point that is calculated with the function. I have an example here in this google(r) picture. In stead of a little dot at the end of the line, it...
  18. J

    hide data in pivot table/diagram?

    hi i guess it's quite simple but....is it possible to hide some data in a pivot table /diagram, but still sort by the data? if i have two coloums name and hours a 10 b 20 c 30 d 40 e 50 f 60 g 70 is it then possible to sort names after amout of hours - and to hide the hours? thanks jorgensen
  19. J

    Diagram - group by

    I have an table that looks like this: <tbody> Group 1 Subject A 1 Group 1 Subject B 3 Group 1 Subject C 4 Group 1 Subject D 2 Group 2 Subject E 3 Group 2 Subject G 2 Group 2 Subject Z 1 Group 2 Subject Y 5 </tbody> i can't figure out how to create a diagram, that groups the...
  20. M

    Getting the y-axis values from a diagram

    Hi! I have an Excel file containing a diagram. The values are in a separate Excel file, which has been destroyed. Is there any way I can "extract" the values from the diagram? I know I can point at the graph, but there are quit a lot of them.

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