charts

Hello! I use named ranges in charts and VBA to change the named ranges so that I can update hundreds of charts in an automated fashion. Let's assume a have a chart that has series1 named range1 and series2 named range2 and i want to use vba to change this so that series1 references named...

Very strange behavior here. I have a new laptop from work. On my old laptop, when I copy a range from an excel sheet (control-c) and paste what is held on clipboard into a different location in the workbook (different location in same sheet or into a different sheet), the chart(s) are retained...

Hello, I need a bit of help with VBA. I've been programming in VBA for about a year, and I come here very often to find answers for questions I might have, but this one is stumping me. I'm developing a product where people in my org can use different templates to create different charts. Each...

Hi, I have multiple data series provided from a source in a format similar to SeriesName1 NameTitle DataPoint1Title DataPoint2Title DataPoint3Title Person1 DataPoint1 DataPoint2 DataPoint3 Person2 DataPoint1 DataPoint2 DataPoint3 etc SeriesName2 NameTitle DataPoint1Title DataPoint2Title...

I would greatly appreciate your help with charts. I'm new to VBA and I just don't understand how to apply information from other posts to my issue. I have 3 line charts and 3 column charts on Sheet 1. The data on sheet 2 is by month and updated monthly; therefore, the number of rows change month...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...

I created a VBA script that adds charts and slicers to my worksheet, but for some reason they don't work after adding them. Now, once the charts and slicers are added I would go and select on the chart, right click and click "select data" then click ok. Once I do that the slicers work with the...

Hi folks, I am not very versant with chart objects and keep getting stuck with the following problem. Thanks for your help! I have put a simple version of a minisheet below with data. I could not figure out how to capture the charts in the minisheet so an image of the "desired result" is...

First time I'm creating a post as I think I'm usually okay at finding solutions in Excel, but this has got me scratching my head. I'm trying to create a chart that shows a vertical list of categories that each have a value, and whiskers that plot the range in which the category values should be...

Hi, I work on a tool that formats Excel charts for best fit to a powerpoint template. My organisation produces projections on different kinds of topics. We make lots of graphs with dotted series for the projection period. Before copy to Powerpoint it is necessary to tweak the dotted series so...

Dear Excel Experts -- I have a stacked bar chart that I am working with that is starting to out grow even 11x17 (Tabloid) paper sizes. I was trying to figure out how to have excel split it so that it would span multiple pages. Ideally I would like to have the data table on the chart also...

Hello. I am trying to chart the monthly median duration of a project and while I can chart everything perfectly using columns B and D (Month and Seconds - see first image below) what I really want to do, is use the data from columns B and C (Month and MM:SS). For clarity, the figures in column...

Fairly noob here. I have a list of Person names on another sheet. I want to automate building a separate monthly trend chart for each person and paste them all onto a new sheet, one right after the other. Will this code work? Worksheets("Report").Range("A4").Value = Agent Call...

Newbie here. I'm trying to create multiple charts (i.e. different chart objects with one graph on each). I found a code on youtube that is linked in the comment that I'm modifying. For now I want to be able to give StartRow which is a starting point and create a scatter plot of the next 700...

I’m trying to use the data (see images below) to have three data points for each dot on the scatter diagram. I need each series element to be custom selected data (not fixed label) so that when I hover over the dot all three data points are visible. I can do this manually; however, I want to do...

I have a macro that goes through all the charts in my workbook and changes the series inputs (in this case would change row 18 reference to row 19 but can obviously be amended as needed) I'd like to amend this macro so that I can just amend the charts in my selection instead of the entire...

Hi all, I'm wondering if anyone is able to help me. This is driving me crazy! I have multiple charts which contain environmental monitoring data: These are based upon data pulled from colums containing dates sampling took place and then adjacent columns containing microbial colony counts. for...

I'm trying to write backwards compatible code to allow me to access a filtered series on a chart without using the FullSeriesCollection (available 2013 +) object. However, the normal SeriesCollection object doesn't have access to series that have been filtered out of the chart. Is there a way...

I need to make something like this in Excel. Four shades (I'll change the color) indicating quartiles - just four even shapes to represent. The numbers on the bottom represent the quartile value. The yellow marker is where the person is on that said scale. I've tried stacked columns and...

Hi all, I am trying to make a chart that skips points that are not numbers. For the x-axis my values are coming from this named range formula (paintMSdatapointnumber) which shows the last specified number of values. =OFFSET(' Paint'!$A$14,COUNT(' Paint'!$A:$A),0,-' Paint'!$X$11,1) I thought...