diagram

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

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

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

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?

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

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

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

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

does anyone has a VBA code for creating fishbone diagram?

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?

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

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.

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

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

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

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

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

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

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

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.