charts

I have created one online excel file, and after 2 months when i try to get into the link, shows me a window and tells me that "Too Many Objects, There are to many objects (charts, shapes, pictures etc to display. ........)" But in this file i don't have, charts shapes etc.. How can i fix it?

Hello all! I have some charts that I am populating from pivot tables. The data I am working with is sorted by fiscal year (FY) on the X, or horizontal axis. I see that excel lists the months chronologically, however (Jan-Dec from left to right), however I need the months on the chart to...

I keep getting it to work in little chunks. As soon as I try to make it loop, I get errors. Assumptions: 1 workbook Varying # of sheets Varying # of charts on some (but not all) sheets Some, but not all, charts are column bar charts Goal: Procedure that goes through all the charts, on all the...

Hi I have a macro to hide/unhide columns and update charts on a sheet. There are some areas where users can update information, but the rest I want locked so they can't accidentally mess up the formulas. I tried inserting ActiveSheet.Unprotect at the very beginning and ActiveSheet.Protect at...

Hi Please do kindly assist me, I would like to know if it is possible to use a single drill down and drill up function to update all the charts in my work book? if so please kindly guide me on how to get this done.

How do I choose the source for labels and data for a chart in excel? What I want the chart to show is the label on the left to show Item name, then a line to track the sales month over month and the month and the bottom label to show the corresponding month. Also, if possible add another...

Hi ! i've been looking into this type of conditional formatting but doesn't seem to find the solution ... hope someone here could help me In a waterfall (so using the typical excel solution with different ranges of data: start/end, positive/negative, etc), am using dynamic values for the...

Our ERP generates reports that contain charts. When the reports are exported to Excel, each chart is rendered as a picture object. I'm looking for a macro that will find each picture object in a workbook and ADD A CHECK BOX IN THE UPPER CORNER. I've added a thick red border around each picture...

Hi, I have an interesting case with line charts. There are 4 tables and 4 line charts in linked file. 2 of the charts show 0 point on x axis and the other 2 dont. I can set the maximum amount of x axis to be zero, but it will not work if numbers are positive. I know there is a logic behind...

Hey all, I am trying to duplicate a spreadsheet from a workbook to another, withoutchanging the formulas or the datasources of the charts it contains. The trickis that the worksheet I want to duplicate has (tons of) formulas and graphsthat use data from other worksheets. If I use the duplicate...

Hello everyone, this is my first question on this forum, so first of all Hello (: I have seen this Line Chart, I can't examine it because I just have a picture of it :/ How can I make a Line Chart just like this one? I mean I can make a chart each of them but in a different charts, so I have no...

Hi everyone! I'm stuck trying to create a custom scatter chart. I have the following columns: <tbody> Name Angle n0 Value Angle n1 Value Angle n2 Value Frank 5 12 12 22 23 40 Peter 7 15 17 33 28 38 </tbody> I need a chart with Angles (n0, n1 and n2) in the x-axis and Values in the...

Hello guys, im creating visual representation of my data, and i want to create charts. The code to create the chart is: Range("T1:T32,V1:V32,X1:X32").Select ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select ActiveChart.SetSourceData Source:=Range( _...

Hi all, Excel 2007 I have created a macro to create charts. This macro decide creation of 3D or 2D charts based on parameters selected for X and Y axis. If parameters for both axis are selected is gives 3D chart. If parameter of single axis selected giving 2D charts. Every time it deletes the...

Hi Hoping some genius can help! I have some Pivot Charts (Bar chart) that come from data within the data model. I need to move the bars as they are not in date order. They should be November, December, January but they are in A-Z. Usually if there was a pivot table I would move around the...

On a spreadsheet I have there are a number of bar charts that are linked to a drop down box to select the criteria which feeds it from my data source. All this is working fine, but the issue I have is that the different selections have a wide range of scores so if I just have 1 axis either some...

Hi all, I am currently going through the process of making charts dynamic by using named ranges and the OFFSET function. Most of our charts show 13 months and I have achieved that with a named range called Months_13 which is defined as below. =OFFSET('Input Screen With...

Hi Everybody, I am having a problem with Excel VBA codes. The code that i am trying to do, makes a prediction with the chart. But, i don't know why, every time that i run the code, excel just start not to responding and crash it all. (I am from Brazil, so, sorry for any english mistake); It...

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