charts & graphs

HI, I have been working for a while on an spreadsheet that has a number of charts that are updated using a VBA script that is used to either enter data manually or extract from a data file. Most of these charts have no problem and the updates occur correctly. However one is a Radar chart and...

Hi, I have a chart with multiple data lines. One of the data lines goes above 100% and so in order to see that line, I have to change my maximum.However, I am not allowed to visibly show any percentages above 100%. The data line still needs to be visible but just not the percentage. How...

Hi I am writing this code and getting stuck at line oChart2.SetSourceData Source:=PT2.TableRange1 Dim data1, data2 As PivotCache Dim PT1, PT2, PT3, PT4, PT5 As PivotTable For Each ws In Worksheets If ws.Name = "Bidding" Then Application.DisplayAlerts = False Worksheets("Bidding").Delete...

Hi, I want to display prices using a step chart (Y=Price, X=Date). The reason I need Step Chart and not a regular line chart is because the prices remain the same till new update arrives. Anyone did it? I saw explanations how doing it on the web, but all of them used a predefined range...

Hi, I have two list: M1_LIST = values (like 1, 5, 6 etc) Country_all_list = values names (Audi, BMW etc) Now I'm creating chart: Dim charts_1 As ChartObject Set charts_1 = sCountry.ChartObjects.Add(Left:=300, Top:=175, Width:=400, Height:=300) With charts_1 .Chart.ChartType =...

Dear All, I am struggling trying to set up a code in VBA to create a chart in the active w/s. This chart should be a scatter line with no markers. The x values are constant for all the series (column A from A19 - the end will be dynamic). The y values will vary. The number of series will also...

Hi, Just wondering if anyone can help me or give me some advice... I have some data I'm wishing to visualise, instead of having it in a table. I have a list of products & cities and year (only 2 years). I want to show the variance of these products in each cities by year.. I was thinking of...

I cannot find the setting to adjust the spacing between color swatch and text on attached chart. Can someone provide assistance? Thanks. http://experiencethewoodlands.com/wp-content/uploads/2015/01/1-31-2015-10-02-46-AM.jpg

Hey Mr.excel :) I work on a project, and this project contains alot of charts. We have 4 sheets with data and each sheet has a chart showing the over all progress, and then a chart showing the lastest 3 day progress. My question is: - Is it possible to make a macro thats update the 3 day...

This is going to sound like a weird question, but is there a way to add a line to a pie graph at a certain percentage by formula. The practical purpose. Different departments have a different percentage goal and 1 report allows you to select to department and see what percentage they are at...