1. S

    Show true % of Grand Total as label on pivot bar chart

    I am using Power Pivot in Excel Office 365 and created a bar chart that currently shows the count as the label. I would like to show the label as a percent. The problem is I have the chart filtered to show only the top 8 items by count and when I convert the label to a percent of total, it is...
  2. Worf

    Organization chart with VBA – Part 2

    This is a continuation of the article mentioned below; instead of updating, I decided to create another one. Now there is an option to make a top to bottom chart. As before, the source table goes on a sheet named “fshap”. You need to insert two sheets named “tdata” and “secdata”. Part 1 Dim...
  3. C

    Add PivotTable Chart using VBA

    I'm new to VBA and I dont know how to create a sub that makes a PivotTable Chart appear with a Title, Axis Title, and extended size also. Can anyone help?
  4. S

    Power Query to download historical stock data from Yahoo Finance

    I am using Power Query to automatically download historical stock price data from Yahoo! Finance into Excel. The URL is Invesco QQQ Trust, Series 1 (QQQ) Stock Historical Prices & Data - Yahoo Finance It populates a worksheet with a year's worth of stock prices with the following columns...
  5. Z

    Charts help or recommendations

    Hi, I'm trying to create charts and need help with how to create neat and interactive charts to impress the board members. What I have are below data and my current charts that I don't think it's impressive: First Chart: Data: Country Jan-20 Jun-20 Change AA 3,486 2,341 0.11% BB 194...
  6. Worf

    Organization chart with VBA

    Smart art can create organization charts, but it will have formatting limitations; the code below overcomes that. Prepare a source table containing the following information: Columns A and B – the relationships between two elements. The shape fill color will come from column A. Column C –...
  7. 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...
  8. 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...
  9. 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)...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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.

Some videos you may like

This Week's Hot Topics