charts & graphs

We have a file that contains our daily metrics across the company that gets updated every morning. We are interested in setting up some trend charts at the top of the sheet where we can select the metric in a dropdown and update the chart to show the last 7 days of data (or potentially other...

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

Hi all Apologies if there were similar post, if so can you please link me to them. I have a single excel sheet downlaoded from a SharePoint list that gets updated daily. It has deadlines, multiple goal deadlines, multiple statuses, financial information. From this one datasource i want to...

This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing. Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup? It is also crossposted here, no answers so...

Unable to create a simple chart the selected data stays red see example below.

I have a chart with series data in cells B1:B10. The chart itself is in cells D5:J20. When I copy the entire columns from column A through column K, and then I move to sheet 2 and paste into column A, the series data is pasted in cells B1:B10 but the charts are not pasted.....in fact, if I...

Hello, I have always been interested in the dynamic filtering other programming languages have. I know excel has timeline filters but I am looking more for something like the following charts. Overall, the functionality works as following. The user can use one of the two scrollbars below the...

Greetings, I have a dynamic chart in a dashboard that changes based on what year I select. Some of the items have no data for 2021 but has data for 2022. How do I hide the line items by year which currently has no data?

Hi, sorry a bit unfamiliar with terminology so searching hasn't helped, but: I'm looking for a way to build excel charts where the # of charts is dependent on lines in the data file. IE 5 lines are in data file : 5 charts are generated, 1000 lines in data file : 1000 charts are generated. Can...

I have an issue where the pivot charts are plotting zero values, NA values and blank values as a horizontal line. I just want a an single line starting at 10 in Dec-20 that goes to 0 at Feb-21 then back up to 100 at Sep-21. Instead I am getting a flat line with inflections at the months with...

Dear Experts, I have following type of data. Names Jan-2021 Feb-2021 Mar-2021 John 55 65 70 Peter 1050 2070 1500 Hyde 8 7 3 I am looking for an easy option to plot line charts for each row (Names - Months). If there are 3 rows, I want 3 different graphs. I have tried sparklines but...

Hello, I am trying to write a macro that builds a chart when it is run. However, if the chart already exists (ie if the macro has already been run at least once), I would to delete the existing chart and create a new one. To be honest the whole ChartObject vs Chart thing is not very clear to me...

Hello. My boss is asking for a chart showing cases potential loses vs actual loses despite over asset growth. He wants to highlight the actual loses were well before what they could have been. I tried to use bar or line charts but it does not "tell the story". Sadly, I am not great when it...

I have a chart embedded in a worksheet plotting 2 parameters. I need to do 2 things. 1. I want to use VBA to dynamically scale the axes whenever the data table updates. The input table is in sheet1 The chart is in sheet 2 Code similar to that below would perform the function required, but i'm...

Hello excel world. I am in your debt. I need your help if you are willing to help me... I am sorry for the inconvenience cause in the pass... Please read my concerns: #1 I have "2" workbooks name: Unemployment_Rate GDP_Annual_Growth_Rate_% #2 in "Unemployment_Rate" workbook. I have "1"...

Hello excel world. I am seeking advice from advance excel gurus on this forum. Here's the concern. I found this code with its photo below searching online: string strCountry = US; // Set country ( sheet name ) plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>]...

I am sure that there is a super simple solution, but I am drawing a complete blank... I have my table set up like so: Employee 2020-05-01 2020-05-04 2020-05-05 employee1 $100 $75 $125 employee2 -$25 $50 $200 I would like to create a chart that has the employee names on the vertical...

Hi All, I'm a rookie in VBA and I have an Excel VBA issue that is driving me crazy. I have created dynamic charts that select their data using an offset formula and a defined range. I want to color the columns of the charts according to the second row of the sheet, but the numer of columns...

Hello Excel Gurus, I'm trying to link my excel tabs sheets to a powerpoint template. However, whenever I run the macro, the charts overlaps in the slides. Is there any way where I can set the slide view to 100%? Whenever I open the PPT, its always set to 115% - not pretty sure if this is the...

Hi, I have a very basic question about plotting data in Excel charts. My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...