• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

2 Row Header Dynamic Chart?

Stephan

Member
Dynamic Charts, following examples data organised either Horizontal or Vertical.

Edit to include 2 Row Header, hence in Chart the Axis Bottom shows 2 Tier cascade of Defining Categories.

Imagined this would be easy but in Excel 2003, uncertain to find the answer.
 

Attachments

  • DynamicChartRanges#HORIZ.xls
    29 KB · Views: 0
  • DynamicChartRanges#VERT.xls
    32.5 KB · Views: 1
Further edit:

Dynamic Chart to be edited to work with 2 Row header in file below:

See File Zip: http://www.hkrebs63.karoo.net/files/DynamicTable&Chart_EDIT.zip

Dynamic Table within File: UKSOC2016##.xls

Dynamic Data Table Tab: Table1

Dynamic Range: D289:F571

OccupationsSubGroupUK Tab shows Dynamic Chart that includes column spaces, above edit to exclude column blanks.

Dynamic Chart within File: DynamicChartRanges#VERT.xls
 

Attachments

  • DynamicTable&Chart_EDIT.zip
    544.5 KB · Views: 4
Back
Top