1. K

    create chart for an action (time specific) along the month

    i work for a pharmaceutical company. Please help me draw a graph. For a given reactor, if batch reaction time is "x hrs" and it will keep continuing all along the days may be for "y hrs" also. Plot a graph with "date" on X-Axis and batch reaction time ( x hrs or y hrs) along the length of...
  2. R

    Automatically Update Code

    I have a code that changes the range of data for a chart as more values are entered. I want the user to enter their values and the chart to automatically update but am unsure how to do this. The code works fine when i manually run it, so the only challenge is making it run by itself. Any help...
  3. M

    Replace charts in a Word document at bookmarked locations

    Hi there, I have an Excel spreadsheet and a Word document that work in pair. The spreadsheet is reviewed and updated regularly so the charts there represent the most up-to-date information. On the other hand, the Word document which contains the same charts (previously pasted as pictures)...
  4. F

    Excel chart - Data labels, word wrap OFF

    Is there a way, using VBA code, to ensure there is no word wrap in data labels. What I have below does not work. 'Activate chart ActiveSheet.ChartObjects("Chart 1").Activate 'Data range ActiveChart.SetSourceData Source:=Range(Cells(1, 1), Cells(5, 5)) 'Data labels - aiming...
  5. R

    Chart Formatting VBA

    I have a chart labeled "Time Spent versus time allocated" and it has a code that will update the chart when new data is entered. However from looking at the bar chart you can see that the formatting of the bars and the labels are not quite right. Any idea of how i can set the formatting...
  6. R

    Trouble making chart dynamic

    Trying to make my "time spent versus time allocated chart" update when new values are inputted in the chart below it. Cells K35:N60 are populated with formulas that will only show a value if they are inputted on another sheet. K35: =IF(ROW()-ROW(K$34)<=SUM(IFERROR(--(('Project - Gantt...
  7. D

    Variable chart Help

    Hi Everybody, first time to mrexcel. I had a question with a spreadsheet Im constructing. I want to make a chart that changes everyday. I have inputs that are produced 2x daily. What I would like is a chart to display a price change over time without stretching the entire chart out...
  8. R

    Automate Chart

    Hello, I am trying to use data that is displayed in this chart in columns R to V. However I want to only include rows that have a value displayed in my data for my Gantt chart. I am trying to figure out how to insert the correct data in vba and was wondering if I could get some help because this...
  9. R

    Live double bar chart autoupdate

    Hello, I am essentially building a dashboard that pulls data from the "Yellow picture". My "Time Spent versus time allocated" chart only pulls inputted values. I want my chart to grab data on the "Time spent versus time allocated" chart from K35:N60 but only using data once it is inputted so it...
  10. R

    Automated Gantt Chart

    Hello, I am trying to make a gantt chart that will automatically update when the data is changed. More specifically I would like the bounds of the start and end date refer to the "Min Start" and "Max End" dates. I also am trying to get the data to only capture real values and not blank rows so...
  11. Z

    Map Chart

    Hi! I'm creating a bubble chart that has a map in the background. The bubbles size depends on headcount but I'm facing I have headcount that is 1000+ and some headcount that are 4 and 25. These headcount won't be visible enough on the map, is there any way I can make all the bubbles appear in a...
  12. D

    Saving Chart as image using VBA not working when pc is locked

    Hey all. I am currently weiting a program that automatically runs at 6am using task scheduler. It is to make a range of data from sheet 1 and save it as an image (i am currently doing this with the chart.add method). I have found that it works fine when I am logged into my username. What i am...
  13. J

    I need to replace 0's with NA

    Good morning, I am looking to update a dynamic getpivotdata table so the results can be charted in a bar chart (a pivot table is used to summarise the getpivotdata table so only relevant cells are reflected in the chart). The issue is that the getpivotdata table includes REF errors that impact...
  14. R

    Hide data labels with zero values WITHOUT changing number format

    Hi, How to hide data labels with zero value? I did a bit search but all solutions suggested are by changing number format. As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.
  15. S

    Using listobject name reference in chart series issues after update

    Hello! I've encountered very weird behavior of Excel after latest update (semi-annual channel). Everything was working perfectly for over a year now. I've created addin (VBA), that creates charts automatically from pulled SQL data. I used following format for series data definition: SERIES...
  16. D

    Excel form and chart related to distributing overtime based of response time to bid and how many times they've taken OT

    I'm looking to make our schedulers lives easier by creating a chart based for giving out over time to our front line employees. we do so by email bid. and email goes out a week prior with available dates and shifts. employees then respond what dates they want to work. they are then selected...
  17. Worf

    Dijkstra's algorithm with VBA

    This article shows how to use Dijkstra's algorithm to solve the tridimensional problem stated below. Dijkstra's algorithm - Wikipedia Actually, this is a generic solution where the speed inside the holes is a variable. The original problem is a particular case where this speed goes to...
  18. O

    Resize the size of a Chart when pasting from Excel to Word

    I have some VBA code Charts("Chart5").ChartArea.Copy .Selection.GoTo what:=wdGoToBookmark, Name:="FG5" wdApp.Selection.PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, Placement:=wdInLine, DisplayAsIcon:=False I'm trying to paste into word but the chart just pastes...
  19. M

    Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells

    I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...
  20. F

    How do I make the color gradient of my surface chart to match my "heat map"?

    Here is my surface chart and the colors clearly does not match those in my heat map How can I fix this?

Some videos you may like

This Week's Hot Topics