Forum Discussion
annanosowicz1993
Jan 10, 2019Copper Contributor
Excel - graph problem
Hello, I need your help with axis X. Could you clarify what should I do to keep the scale. At the moment I have seven values and the distance are the same between each of number.
annanosowicz1993
Jan 10, 2019Copper Contributor
Dear, I need exaclty the same graph like this one
SergeiBaklan
Jan 10, 2019Diamond Contributor
For data as this add helper column
Add line chart on first 3 columns
Right click on chart, Select Data, remove first series and change X axis on helper column
Click on X axis to format and select Date axis type.
Select Data and add one more series with Y from first column
Select Data labels and deselect horizontal axis
After that cosmetic, format as desired