Windows 10, LO 7.4.0.3. If the x-axis in my Calc line chart is the dates from column A in a sheet and if I have highlighted some of those dates in the sheet (eg: with a background colour) can I have that same highlighting automatically appear on those dates in the line chart x-axis?
Based on the complete lack of response I guess the highlight idea is impossible, but I thought someone might have a way to make the x-axis labels inherit the font attributes from the sheet. Perhaps a feature for a future release?
As a workaround, you can copy it to Draw, convert it to curves, ungroup, then apply direct formatting.
As far as I can see neither the x-axis nor its marking are based on distinct graphical elements. Therefore your feature suggestion would require lots of changes. In addition it may get in conflict with the odf specifications about how to store everything to a file. A few months ago, however, I considerd in what way the labelling of data points in Charts might be enhanceable and wrote a raw sketch for the purpose. Since I don’t need such a feature actually, I left that site of works in a very disorderly state. If you are fond of programming workarounds you can get what I have. It contains a raw proof of concept, and you might use it with your own intentions in mind.
Would like to take a look, thanks!
As already told I only have a demo under construction not touched for a while now. My intentions were completely different: IMO the so-called data-labels are rather useless as they are implemented currently. I think they should support marking /emphasizing/commenting inside the chart by textual elements editable outside. For the purpose charts would need to support respective connections to data ranges. Actually I succeeded half way with an attempt to use the existing variant of data-labels showing the common “categories” and to replace their contents with the help of user code by what I want to show then. The ranges to take these contents from were described in cells below the names of the series …
For a test run of my “proof of concept” you need to permit the execution of document macros. Then first call a routine pressing the button ‘As Currently Is’ and after that the button ‘As Should Be’.
I feel sure it doesn’t pay for you to study the code in detail, and to adapt it to your needs.
I therefore also attach a newly made little demo about how to “color” intervals of the x-axis.
tdf38760_DataLabelsPerSeries.ods (57.4 KB)
coloredAxisIntervals.ods (20.1 KB)