chart series

I have a clustered stacked column chart. The stacked columns are set to 0% gap width, so they actually appear side-by-side rather than on top of each other. This works wells for me, except when it comes to data labels. Because the series are defined as stacked, the option for "outside end" is...

A quick question for anyone that can help: How would I go about looping through a specific number of chart series? I am interested in scaling the primary y-axis using the first 7 chart series (the 8th series is on the secondary axis). Thanks

Hello, I am using Excel 2007 and have a protected sheet containing a macro within that sheet. I want the macro to change the data and it does so when the sheet is unprotected. Once I protect it, I am getting this error - Method 'Name' of object 'Series' failed. How could I fix this macro so...

Hi all, I'm writing a VBA macro in Excel (2007) to generate a series of plots. This macro is intended to get iterated across numerous sheets and workbooks. Because of this, I need the macro be generalized and the only stumbling block I'm encountering right now is that Excel is forcing me to...

I have the following issue with a named range within a chart when copying the tab. Using excel 2010. NAMED RANGE BAND ='TAB1'!$C$32:OFFSET('TAB1'!$C$32,0,COUNTA('TAB1'!$4:$4)-2) Selects only the fields in row 32 of table (in tab 'TAB1') from C32 where there is an entry in row 4. The end...

Hello, I have a single data series in a simple x-y chart and I recorded some VBA code to format the data series line, its marker fill and marker border. What I've found is that when I just change the marker border (and record those actions via the Macro Recorder), what gets recorded actually...

Dear All, I am struggling with dynamic charts but my series lose the path and I end up with: =[0]!ChtData before the [0] was a filename. Do you know why this happens? P.S. I need to be honest - this happens when I move the chart to PowerPoint, but maybe you could give some hints? Google...

Hi, I have a chart with data table and 6 data series: target1, data1, target2, data2, data3, data4 (for 4 months) target1 and target2 should be linear graph, data1-data4 should be column/clustered column graph. I'd like the data table to show these series in order: target1 data1 target2...

The formula used to create the marked series line. =SERIES(Rolling_window_data!$B$2;Rolling_window_data!$A$3:$A$122;Rolling_window_data!$B$3:$B$122;1) The statistics in Rolling_window_data. I need the marked line to be different from/to a point in time (x scale), depending on the backfill...

I have 5 sets of data I'd like to be able to display using only one chart that is controlled by a listbox. I've tried a couple of different lines of code and searched to find an appropriate answer for this without any luck. Anyone willing to help? Private Sub Worksheet_Change(ByVal Target As...

I have posted this on the Home - Microsoft Community site but I thought I would post this other places just to see if anyone is familiar with this issue.<o:p></o:p> <o:p> </o:p> I have a very peculiar issue with series in charts that have been converted to values once links are broken. I cannot...