charts

Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...

Good afternoon all, I want to select 3 columns of data from my spreadsheet which will be displayed in a chart on my dashboard, for example Column headers are Jun 19/Jul 19/Aug 19, when I get in to the month of September I want the selection to move along one column and then select Jul 19/Aug...

I have a large dashboard that once complete will have c300 pie charts and need them all to have specific formatting. I have recorded a macro of me applying the formatting to one chart and looked up a macro to loop through all charts in the workbook and tried to combine the two to create the...

I created a chart but can't find it. Is there a way to find charts? It just has a generic name like "Chart1", "Chart2" etc. I thought maybe the selection pane would help. On it i've tried selecting or double-clicking the objects that are listed, but nothing really happens when selecting an...

Good Morning, I am attempting to combine a Dynamic rolling chart with aCombo box to select different data streams. For example: The data sheet has sales volumes for 3 customers frompast 36 months I have been able to produce a rolling chart using OFFSETformula and named ranges which...

Hi all, first time poster, long time lurker! I'm currently fighting with a dataset at work, where I need to show Jan-18 & Jan-19 data next to each other. However, no matter how I arrange my data set, the Jan-19 goes to the other side. Now, I get that it's following the sequential months/year...

I have a general question about how to set up a slicer used with several power pivot charts. I have two charts that share a timeline and display company totals and I have a slicer that allows for individual vendors to be selected. Everything works as intended, the only problem is that for this...

I have an excel doc that has 15 charts in it, I can export the charts into word but does anyone know if its possible to place them into specific parts of the word document? If is it possible could someone point me in the right direction of code to use? I have tried several different ones (like...

So I have a basic Macro to select some data and create a chart - this works perfectly. The problem I have is that I need to create 78 of these charts. I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and...

Gantt charts typical display a different task or job on different lines. So one project will have five lines if it has five different phases. It it possible to create a Gantt chart with all phases on one line? I want to be able to look at different projects and see how their timelines match up...

When I attempt to use the following to update series values using an array, The series don't maintain their coloration and defaults to one of the available presets. With Chart_Dictionary.Item("Non-C").Chart For L = 1 To 4 .FullSeriesCollection(L).XValues = Date_Range...

Hello, I am really having trouble figuring out how to do this and would greatly appreciate any help. I have a column of data and I need to analyze ranges of numbers like this example: 10.2 5.1 2.6 11.6 5.7 I want to make be able to calculate for example (and eventually convert to charts)...

Hi Friends, I have a Userform with a combobox "cmbchart" and i have a sheet with some charts , "Charts". In the comboBox there should be 3 Chart type listed, Column Chart , Bar Chart, Line Chart . Based on the user selection my chart in "Charts" sheet should be changed (Column,Bar,Line...

Hi all, so I am using Pivot Tables to create charts (Pie, Bar, Donut...!) on Excel 2016, from the data. I have formatted them rather nicely, but whenever I create a new one, is there a way to copy the formatting of one to another? I have tried Ctrl+C, but no paste special (format) dialogue box...

I'm not so good in VBA so I hope someone with more knowledge can help me. I have a *.xls file with nine Worksheet, in each worksheet there are two charts. What I want to do is to move the two charts from worksheet one to first page of a powerpoint file, place the two charts next to each other...

I created a "template" worksheet, in which users create a copy of said template and rename to a variable name. On the template sheet, there is data and 2 charts that reference the same sheet name as the charts sitting on ( data is not on another sheet). After creating a copy of the sheet, the...

Hello, I'm new here and I was trying to write a macro that can create 2 pivot pie charts with a dynamic data range. What I did was to record the macros to create a pie chart with connection only, then did some google searches how to express a dynamic data range. Unfortunately I have no code...

See the included screenshot of the issue. Despite how it appears, the charts are NOT Pivot Charts. Instead, the pivot data is feeding a table that's located elsewhere on the page. This file is massive and would be quite difficult to share (privacy issues, as well), so I'm regrettably unable to...

I am writing a macro which is editing data in a different excel file. Let, Excel_with_Macro be the excel file where I am writing the macro Sheet1_EwM be the sheet of excel file Excel_with_Macro Excel_2b_edited be the excel whose data I am editing data_E2bE be the sheet of Excel_2b_Edited and...

I have a bunch of bar charts that need to be updated monthly or quarterly. I would like a quick easy way to update all of the charts when new data is added automatically. The far right bar needs to be an orange color as it is not a complete amount for the time frame. An example would be we...