#2449 - Combined chart: 1 single vertical axis scale & fixed values
Hi there
My objective is to create chart: revenue vs target revenue by fiscal quarter
- Using combined chart is it possible to have 1 single vertical axis scale so if I have a chart showing the 4 fiscal quarters, the revenue by quarter and the target revenue are direct comparable?
- How can I add the fixed target revenue by quarter, considering this data is not stored on the database but must be entered manually?
Regards
8 years ago
Hello Tiago,
If you need to use only 1, not 2 vertical axis, you should use either Column Chart type or Line Chart instead of Combined. Combined chart will always give 3 Axis. Or you can also try to add both items to single vertical scale (and leave empty the second or add both to the second as well), if chart allows.
Generally Report uses only stored data in the database, but you can try to add Constant value to Calculated functions. Constant will be mutlipleid by # of detailed data, but in order to avoid the multiplication, you can use AVG of this calculated function - So you get same constant.
We hope, this was helpful. But if it was hard to understand, we can schedule a web meeting to try this together ;).
Best Regards, IT Sapiens Team