charts

Hello, i'm trying to align grid lines of 3 separate Excel charts as seen on image (i'm new to charts), representing Actual sale by products and % variance to Plan/Prior Year. Manually i cannot align them to the exact alignment (check the mismatch on last grid lines below): Is it possible to...

Hi, I have researched and modified code that allows my 4 charts on one of my worksheets to change the maximum y axis value to a number such that the series label (outside end) does not show outside the plot area. The code that modifies the chart runs while I'm on a userform interface with...

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...

i am interested on draw charts on a USer form, specially in a Multipagecontrol, how to do? Thanks

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...

Has anyone come up with a report that has a catchy tune using the Audible Charts add in?