chart

I am trying to change the chart type for 2 series. Series 1 should be a Column chart with the primary axis and Series 2 should be a Line Chart with the Secondary axis. I get a 438 error. WHat am I doing wrong. Please help. I am using Excel 2016 Sub Chart1_Update() Set wsPivotChart =...

This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...

Hello, I have about 20 line charts with >30 series in each one which I want to colour based on cells in one of tabs, like this: So I am trying to use VBA to pick up the line and marker properties for each of the series above, but for the life of me I can't find a way to make it go from...

Hey, Is there a way to change the trendline in the attached Sleep view, so that it looks a lot sharper & trend is clearer over the 30+ days. Kind of like in the attached CPU view? Thanks

I'm trying to add a window (if that's even the right term) to a line chart. I've done a mockup attached - it's just a line chart with a yellow rectangle drawn over it. Is there a way to actually add this rectangle as part of the chart and make it dynamic based on cell values? I want it to...

Hi all, so my problem is this. I want to basically make the attached picture in excel. What this shows is a 24 hour day, divided into various chunks of X hours. This I can kind of do with a multiple-series donut chart (I need multiple concentric wedges), however the bands are WAY too thin and...

Hi, I have a chart which fetches its data from a dataset. on the sheet i also have a dropdown list with values in it. I want the chart to use a different data set based on the value of the dropdown list. is this possible? thanks Gareth

I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...

Hi, I am trying to make an line/scatter line chart for trend analysis where there are x-axis and y-axis values in two different columns. In the attached image, I would like to use columns D and I as x-values and E and J as y-values. However, I want the points to display in order of the x axis...

Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...

I have a google sheet that uses the sparkline formula '=sparkline(C6:C)' which seems to automatically add to the sparkline with new incoming data in the C column. However, this data range is not valid in Excel when trying to create a sparkline. Does anyone know how to replicate this to have it...

Hi All, can't seem to find a solution to my problem. I have written a query that returns data from a database that is viewed in a pivot table. I use timelines and slicers to change what I am looking at, this works fine for one table and chart. I want to create other tables and charts also linked...

Can someone please help me understand why the data bar in the second chart (screenshot attached) isn't showing the bar height relative to the percentage like the top one. Tried every setting I came across and it won't show the bar correctly. Thanks in advance!

Hi, I'm looking for a way to change the Offset Top, Bottom, Left and Right values through VBA. The chart is an XY scatter plot. Any help appreciated!

Hi, Im looking for some inspiration. I have a table / spreadsheet that I need to create charts or other forms of vision in order to drive focus to the areas which need it most. Using the sheet: Excel File The sheet is basically looking at 7 machines, R1, R2 etc... Looking at R1 as an example...

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

Hello all My question is related to charting a set of data in a specific way that I can clarify as we go on, but the jist of it is included below, I am in a bit of a pickle with a task I have to convert some MATLAB code into VBA. Usually my methodology to do this is to develop each chart...

hello to all. I am trying to create a script that extracts chart elements (in jpg) from excel to sharepoint. I'm currently using this script but without results: function main(workbook: ExcelScript.Workbook): ReportImages {...

Hey everyone, I have a fixed table with dates (x-axis on desired chart) that go for several years into the future, but data (y-axis) that only goes a few months. This will be a working file where new data is added each month. I'd like an area chart to show the data across the dates that have...

Hello, I am a newbie working with VBA on Excel. I have been trying to figure out to create a pie chart and a column chart using the following data to show expenses by locations. How would I create a chart that shows expenses based on each location in VBA? Distribution Centers Budget Proposal...