how to create a bar chart with data in an array

**eternity_forget** · 06-09-2009, 07:41 AM

i got data in two arrays in the macro, let say a() and b()
and i want to get a bar chart of plotting a() as y-axis against b() as x-axis

i got some codes like this if i post my data in the worksheet first, but i dont know how i can do it directly ... i dont want to show all my data in the worksheet...

"Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range(_ "K1:L10"), PlotBy:=xlColumns
....."

**tigertiger** · 06-09-2009, 08:05 AM

Originally Posted by eternity_forget

i got data in two arrays in the macro, let say a() and b()
and i want to get a bar chart of plotting a() as y-axis against b() as x-axis

i got some codes like this if i post my data in the worksheet first, but i dont know how i can do it directly ... i dont want to show all my data in the worksheet...

"Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range(_ "K1:L10"), PlotBy:=xlColumns
....."

I think that we could never make a chart like that, because the range-source of a chart in Excel has to base on real cells in a worksheet.

You may create a chart yourself by making a bar-chart with REPT(....) function
.

**Andy Pope** · 06-09-2009, 08:09 AM

You can base you chart on array data but you will be restricted by the length of the Series formula. ~1024 characters

You can hide the cells as long as you uncheck the option to 'Plot visible cells only'

**eternity_forget** · 06-09-2009, 09:04 AM

Thanks both

but could you please explain in detail ? 'cause i don't really understand ...

@tigertiger - what is a REPT() function ? how to apply that ?

@Andy Pope - can you tell me more about how to do that ?

thanks in advance !!!

**Andy Pope** · 06-09-2009, 09:16 AM

Code:

    With Charts.Add
        With .SeriesCollection.NewSeries
            .Name = "Test"
            .Values = Array(1, 2, 3)
            .XValues = Array("A", "B", "C")
        End With
        .ChartType = xlColumnClustered
    End With

Thread: how to create a bar chart with data in an array

Thread Tools

Display

how to create a bar chart with data in an array

Re: how to create a bar chart with data in an array

Re: how to create a bar chart with data in an array

Re: how to create a bar chart with data in an array

Re: how to create a bar chart with data in an array

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions