| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a question about diagrams.
Hi!
I have data from cell $B$5:$B$8. However I might add data in cell B9 etc. Is there a way for the diagram to always include from B5 to the the last cell in the column. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
a question about diagrams.
nevermind, I found this code to play around with.
ActiveSheet.ChartObjects("Diagram 17").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(2).Values = "=resultatpivot2!R5C3:R8C3" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diagrams with Excel | Charts and Charting in Excel | |||
| Pie Diagrams | Charts and Charting in Excel | |||
| Radial diagrams | Charts and Charting in Excel | |||
| Diagrams | Excel Discussion (Misc queries) | |||
| Can I get additional diagrams for flow diagrams | Excel Programming | |||
Linear Mode
