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...
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...
Dear all,
I have a simple and yet complicated question. I have a bar figure with three years for 13 countries. Here it is:
for each of the countries, and for each of the years, I also have another data (growth rate, if you are interested), that I'd like to plot as a point. So, take for example...
Hi!
I've been trying to look for a way to "merge" two or more bar charts, with no success over google nor MrExcel.
I'm trying to merge two bar charts into one.As said, one image > 1.000 words, here's an image of what i want:
https://ibb.co/bBkdDFf
Creating 3 series and making a stacked bar...
How do I choose the source for labels and data for a chart in excel?
What I want the chart to show is the label on the left to show Item name, then a line to track the sales month over month and the month and the bottom label to show the corresponding month. Also, if possible add another...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.