Does such a thing exist?
I have a dashboard consisting of doughnut charts and a trend graph. Each worksheet is for each person on the 10 person strong project team. On each worksheet there are 36 doughnuts which reference various cells containing the source data, located on that worksheet.
In...
I have created 2 "master" workbooks which we are copying and renaming. I can get the source date for the workbooks to change using edit links but it doesn't change the source data for the charts. Is there a way to change all the chart's source data when you change the workbook's source data...
Hi Guys ,
Can anybody help me with this please?
I would like to take this data to excel sheet .
https://www.billboard.com/charts/dance-club-play-songs/1976-09-11
it is very time consuming to do it manually.
I would like to have Artist in one column and title on the next column if possible.
if...
I am very new to VBA and am having a hard time understanding how the loop feature is working in relation to only charts on the current sheet. I can change an "active chart" with a VBA but need to loop it through all charts on the current sheet. I have been trying to understand it for 2 days of...
Hi,
I have code to export a series of charts from a dashboard to images. The intention is to then disply them on TVs around the building
I have code that will do that (HTML) but the charts are tiny :(
They are nicely laidout for the dashboard but I need larger images for the TV
Is there a...
I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart.
With ch .HasTitle = True
.ChartTitle.Text = aa & StartDate & " to " & EndDate
.ChartType = xlLine
.SetSourceData Source:=Range(RngStart & ":" &...
I am having trouble producing charts in VBA. I am having trouble with the portion in the With statement.
I was receiving an error "Unable to get the chartobjects property of the worksheet class" on the line: With Worksheets("LowDistCharts").ChartObjects(aa)
The properties I would like to add...
I would like to be able to produce a number of line charts and place them into an existing worksheet. Is it possible to have them placed into a sheet in the same way something like Range("A1").End(xlDown).Offset(1,0)
would select the next cell below the last occupied cell? Ideas?
Hi Excel Experts,
I have this 1 workbook containing multiple macros, a master data worksheet and multiple pivot tables & charts in separate worksheets. I thought it would be easier to refresh all pivot tables and charts whenever there is a change in the master data. However, since the pivot...
I just received a new computer at work and in switching from Excel 2010 to 2016 some of my workbooks haven't fared as well as others.
In one workbook that I use daily, I have several stacked area charts. All of the areas are gray with white borders. Even after I change the fill color, it...
I have a spreadsheet that has a load of charts in and I need to apply a template to them all.
This is the code I'm currently using:
Sub SetChartFormat()
Dim Cht As ChartObject
For Each Cht In ActiveSheet.ChartObjects
Cht.Chart.ApplyChartTemplate ( _...
I have a large amount of data that I'm going to need to put into pie charts with only a day or two of turnaround, so I'd like to figure out a way to automate it.
I have data like this, with organizations and the number of actions they did in each county.
<colgroup><col><col span="2"><col...
I have an excel sheet containing several charts & tables, the sheet is protected and all charts are locked.
I would like to make it possible for the users to copy the charts. Either by right clicking and selecting copy or by triggering a macro at when clicking or double clicking a chart.
I've...
Good afternoon
I have a workbook with four tabs, three of the tabs contain charts. I would like help to be able to automatically update the minimum and maximum on the axis as the data changes. All the charts start at 0 and it would make more sense for the minimum to start at a value closer to...
Hi,
I have the following information:
X Axis: Product (Tomato, Apple, Orange, etc)
Y Axis: Date range (Sept 1-Sept 30, Oct 1-Oct 31, etc)
Values: $ made on each product
I want to create a simple chart that will update information based on a drop down menu selected on another sheet.
For this...
Hi everyone,
I have been learning VBA over the past couple of months and have come up with a problem. I have been trying to write code that will paste Selected charts in one sheet and paste them to another. I have multiple charts on one sheet but only want to paste a few of them to another. To...
I am very new to Power Bi and need some help in solving a charting issue. I have multiple charts that use different date ranges in them. 13 month, 12 month, 6 month, 3 month and monthly. How do I have multiple date slicers or a master date slicer that controls multiples for my charts? I would...
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.