I am probably being a bit obtuse here but I am struggling converting my offset tables into bar or column charts that will expand as rows are added. I have upload a simple version of what I am aiming for. In reality the main chart will have 80-100 rows of data and 3 columns. Any and all expertise/guidance gratefully acccepted
Chris
Covert it into a table
Ash
If I had a table the chart would include blank cells, I want the chart to expand as the rows are added
I am not sure if I got what you are looking for but........... check the attached file and try adding additional row.
that is exactly what I need, do you have an idiot (me) guide to explain how the chart data range expands automatically
It is because tables in excel work on automatic nomenclature............. it does certain aspects for you automatically............ like updating formulas and charts
so if i convert the whole area to one table and set my initial area to the existing data it should be automatic?
I would suggest...........Just convert the area to a table which is required.............anything added to it later would auto populate in the chart............... if you want to remove any column or row then you can un-select it in pivot properties.
thanks for your perseverance, I am having trouble with the table on my main sheet as it is based on an array formula and isn't expanding but I will keep at it.
Hi,
If you have a formula array-entered into multiple rows, as opposed to an array formula in one cell per row, that will not work well with a table.
Don
Please remember to mark your thread 'Solved' when appropriate.
thanks for everyones advice on this, I am slowly getting it together
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks