Robert Casaletta
asked on
Dynamic Chart y-Axis Displays Empty Entries
I am struggling with creating a dynamic bar chart that is comparing activity (Category) between visits (Aud & WAV). I have attached what I have come up with so far. I've tried the OFFSET formula method and INDEX-MATCH not to include blanks, but I cannot figure out how to get the y-axis (Category) to work dynamically.
Would appreciate the help.
Thank you in advance.
Would appreciate the help.
Thank you in advance.
Attached?
ASKER
I thought it was attached...hang on, I'll try again...
eeCHART_NO_SPACES.xlsm
eeCHART_NO_SPACES.xlsm
Delete the empty rows of the table.
To add a new category type in the first empty cell under the table AE28, and the table will expand.
eeCHART_NO_SPACES.xlsm
To add a new category type in the first empty cell under the table AE28, and the table will expand.
eeCHART_NO_SPACES.xlsm
ASKER
I am not sure I understand or perhaps I did not explain my request. Are you suggesting to always delete the table rows? The table itself is dynamic; do you know how I can dynamically add/delete rows from the table? If manually delete or add data to the table, then I have also adjust the table in name manager.
I suggest to only have rows in the table where there is data.
Hence delete the empty rows, as you can see in the file.
You delete rows by selecting a cell, or more cells, right click and select delete, and select table rows.
Insert a row using the same procedure, right click and Insert.
A table is dynamic, so when you delete or insert rows, the table range is automatically adjusted.
When you type something in the cell just below the table AE28, and insert with Enter, the table is expanded to include that row.
Hence delete the empty rows, as you can see in the file.
You delete rows by selecting a cell, or more cells, right click and select delete, and select table rows.
Insert a row using the same procedure, right click and Insert.
A table is dynamic, so when you delete or insert rows, the table range is automatically adjusted.
When you type something in the cell just below the table AE28, and insert with Enter, the table is expanded to include that row.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.