diagram

  1. 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?
  2. 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...
  3. M

    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...
  4. 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...
  5. 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...
  6. G

    VBA code for Fishbone diagram

    does anyone has a VBA code for creating fishbone diagram?
  7. 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?
  8. 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...
  9. 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.
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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...
  17. 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.
  18. M

    Makro to create diagrams from a table with 89 columns

    Dear All I have a table with data from a wastewater treatment plant. The table contains 89 columns. Column A is the day/date. The rest of the columns are measurements parameters from Column B till Column CH. I would like to create a makro which create an x-y dot plot with X-axis always Column...
  19. O

    PowerPoint VBA Macro - Organization Diagram Macro Not Looping Correctly

    Hello Everyone, I have searched this board many times for programming VBA Macros in Excel and it has been very helpful. I am working with a macro in PowerPoint, so I was hoping I may be able to tap your knowledge. If this is inappropriate and not "Excel focused" I will remove this question...

Some videos you may like

This Week's Hot Topics

Top