mychart

I have a userform with labels (Label1.Caption = Store-1 & Label2.Caption = Store-2) I want to display on the Chart Legend. I would like to the Chart legend to display the captions of each label. How can I accomplish this? i.e. Legend 1 = Label1.Caption Legend 2 = Label2.Caption Also, my...

Dear friends, Please be kindly requested to help me get over a problem in displaying charts (7 charts)as images in my userform .The problem is when navigating from image to image by using next and previous buttons I get this error "Invalid image 481" error and when debugging the cursor comes...

Hy, I have the following code to put a chart on a userform with multipage: Function chart_v1()LoadSheets Dim MyChart As chart Dim ChartData, ChartData2 As Range Dim chartIndex As Integer Dim ChartName, ChartName2 As String Dim i As Long chartIndex = MultiPage1.Value Select Case chartIndex...

Good day. I have a userform with approximately 50 labels each containing a number which is the latest number in a column of numbers (i.e. I have 50 columns and say 365 rows). I have a code that calls another userform which has a graph when you click on any of the 50 labels (see code below)...

Good day, I have data in two columns - first is just date/time data, second is the variable in question. Normally I just set my ChartData (having declared variables earlier) in the following way. But a lot of the data in column two is sequentially identical. So you might get data in column B...

Hi All, Trying to loop through 72 charts on a single worksheet to update the border color on them. My VBA code fails with a "Type mismatch" on the beginning of the With. Little help please? Code below. Sub PivotBorder() Dim MyChart As ChartObject For Each MyChart In...