areas

Hi I've been populating a bunch of charts. They're stacked areas, the total is done as an XY scatter with a negative 100% error bar to get a dotted line down to the the X-axis. There's a lot of them, about 30. They have all worked fine. All of a sudden, 1 chart is being a pain. it won't scale...

Hi, I am hoping someone can help me with a problem that I am having with formatting on a 2 pivot charts that I have set up. I have set up 2 pivot tables that are showing trend data over a whole year for 15 different areas. I have used the slicer to flick through the different areas. The chart...

The VBA below highlight 1 area for i=5 only. How to modify VBA to highlight all 3 areas (for i=1,3,5) Sub GroupArea() For i = 1 To 5 Step 2 Range("B" & i & ":M" & (i + 1)).Select Next i End Sub

I've tried using the SMALL function, but this doesn't work when you want the 3 lowest results and they can often be the same amounts. My data is pulled from another table via pivot table, and looks like this: <tbody> Area 1 Area 2 Area 3 Area 4 3 2 2.5 2.5 2.65 1 1 1 </tbody> My data...

<tbody> Area 1 Area 2 Area 3 Area 4 Area 5 Lowest 2nd lowest 3rd lowest 1.2 1.6 1.2 1.4 1.7 =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,1),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,2),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,3),$A2:$E2,0)),"") 1.1 2.8...

Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...

I am having two problems dealing with the handling of duplicates in VBA. One is the inclusion of an extraneous row (Row1) when filtering and the other is the failure of CountIf > 1 to return duplicates. Since both are in the same block of code, I am combining my questions. I am using VBA in...