Hei!
Have another problem too. I have a list in Excel with 2 rows. One with names and one with data. The list has 30 rows. I want to create 30 diagrams with all data in bu only showing the name for one of the persons. The other bars should be "nonamed". And is it possible to create all 30 diagrams in "one click"?
Thanks for all tips you might have,
Jonny
Last edited by VBA Noob; 10-14-2008 at 01:15 PM. Reason: Case solved
Can you post example of data layout and chart
To create all charts in 1 click would obviously require code.
Will the example workbook also help solve your other post?
In a1-a30 I have different names like: a1=Ann, a2=Toby, a3=Catherine
In b1-b30 I have different data like: b1=200, b2=220, b3=380
In b31=I have the average av column B. Lets use 270
The chart I would like to create is in Chart1: 2 bars with Ann=220 and the average value.
In chart 2: 2 bars wtih Toby and the average value.
And over and over down to row 30.
Please Login or Register to view this content.
Hi!
Thank you very much for spending so much time helping me to fix this!! Thanks again!!!
Please keep your questions in the thread.
Either one of this will do itThanks for your help!! It worked perfect!! One extra question. I will send out 1 page to each person at my work. Is it possible to have one chart at on each page like Sheet1, sheet2 and so on? Thanks. Jon
Please Login or Register to view this content.
Thank you! Case solved!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks