Hello,
in the attached graph there are 9 rows B9:L17 and these are reported in the graph.
If these rows are all filled in, the graph displays a series of 9 columns see photo1
It is possible if only 4 lines are filled in, only a series of 4 columns is shown, see photo2
I hope I explained myself
max
Last edited by max_max; 12-18-2019 at 02:58 AM.
I see you start another post rather than complete your previous one.
If you want categories to be excluded then you will either need to filter the data and set the chart to not show hidden cells.
Or rebuild the chart data into a contiguous block using formula
Or perhaps a pivot chart would work
Hi andy,
what I'm looking for is for editing in post#1 it's like in the graph in the post#5
if you add values in rows B10:E17 the chart is updated
Ciao Max,
In your attachment, change your named ranges to...
_M1 =OFFSET('9R2'!$B$9,,,COUNTA('9R2'!$B$9:$B$17,"<>"))
_M2 =OFFSET('9R2'!$F$9,,,COUNT('9R2'!$F$9:$F$17,"<>"))
HTH
Regards, Jeff
Hi
attachment post#1 or post#3?
must work in post#3
M1
M2
M3
M4
M5
M6
Not sure what you are saying as it does work in post #3.
I look for post # 1 chart
the change that you made for graph post # 3
does not work after clicking on delete error (button on the sheet)
a spreadsheet formula contains one or more invalid references.
Verify that the formulas contain valid references for paths, workbooks, names of ranges and cells
max
Hi Max,
Sorry I gave the wrong info in post #4.
How's this?
Hi jeffreybrown
your modification is perfect here at home.
To be sure, I have to try it in my office on Monday
Thank you so much
Greetings and many more thanks
max
That is good to hear Max. You are very welcome and thanks for the feedback.
Hi jeffreybrown your modified work well.
Is a change possible?
Also add column C to the M6 (define name) as an attached photo?
Last edited by max_max; 12-15-2019 at 03:36 PM.
Ciao Max,
Change M6 to =OFFSET('9R2'!$B$9,,,MyCount,2)
Hi jeffrey it's o.k.
Thanks you.
max
Hi Max,
Glad it worked out for you. You're welcome and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hi jeffrey.
Your modification works well.
Only a small mistake.
If only the values are entered in 1 row, the names of the ABCD/EFGH column they are only1
If the values are entered in more than one line it works well
max
Hi,
is this latest correction possible?
Hi Max,
How about use a helper column in D.
Thanks Jeffrey
it's a nice solution.
I could hide the column and show hidden data.
But the original file isn't mine, it's from my office manager.
is another alternative possible?
Thank you
I put the as new column A and put it here
the new formula that was in column D.
We leave everything so it is a nice solution.
Thank you so much
Greetings and Merry Christmas
max
Hi Max,
Glad to hear you could make the solution work. You are very welcome and Happy Holiday's to you as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks