Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm very much a beginner when it comes to programming, so hope to
appeal those experts amongst you for help. I have a spreadsheet (Sheet1) which contains data in rows (row 1 has column titles whilst 2 to 189 contain names in col1, along with numbers in col 2 & 3). Name Amount 1 Amount 2 Average 5 10 Smith 5 10 Jones 7 11 Wilson 6 9 What I need to produce is a graph for each individual which shows their achievement against the average. Ie Graph 1 should show Series 1 = Amount 1 for Average and Smith and Series 2 = Amount 2 for Average and Smith. Graph 2 (separate page) should show Series 1 = Amount 1 for Average and Jones and Series 2 = Amount 2 for Average and Jones. etc all the way through to Name 189. I can do the formatting of the graph, but I don't know how to 'tell' it where/how to get the data from. I haven't even begun to get to grips with arrays and stuff yet, so any help at all would be gratefully received. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code that keeps creating a toolbar - where might that code be hidden? | Excel Programming | |||
Creating C++ DLL for my VBA code | Excel Programming | |||
Creating new VBA code on the fly | Excel Programming | |||
Creating new VBA code on the fly | Excel Programming |