goes above that maximum value? Something cool and automated. Thanks,
goes above that maximum value? Something cool and automated. Thanks,
More context, please. Are you looking for something in a chart (what kind of chart?), or something for a table?
Can you post an example spreadsheet?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
help.xlsx
Hope that clarifies. You see the c goes to 10, but I dont know how to make that clear in a nice way on the chart that I have capped at 3.
Thanks so much
Here's one way:
Add two helper columns.
first: MIN(data, cap_value)
second: IF(data > cap_value, cap_value, error)
Then you can use the first+second helpers to build your chart; I stuck the second as a line chart so that the data marker for the line chart can be your "above cap" indicator, while the error code gets ignored by the column.
Thanks Ben, shame there's no in built more elegant function
If you go here http://peltiertech.com/broken-y-axis-in-excel-chart/ down near the end of the tutorial right before he shows the finished panel chart, he explains how to apply a gradient fill effect to a data point to give the illusion that a specific column "extends into the clouds". Would that kind of effect work for you?
Originally Posted by shg
Wow MrShorty thank you that's just what I needed. Brilliant!
Ben Hensel...have you considered anomalous data ruining a graph by making it impossible to see the underlying trend? Best practice? For GCSE Biology coursework maybe! but thanks for your help anyway!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks