View Single Post
  #11   Report Post  
Old October 9th 20, 06:10 AM posted to microsoft.public.excel.programming
Max[_9_] Max[_9_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2017
Posts: 20
Default X Y Scatter Excel Graph X Axis Customization

On Friday, 9 October, 2020 at 2:20:50 am UTC+5:30, Peter T wrote:
"Peter T" wrote in message
... Another way would be to start with a dummy Line series with all zero Y
values (assuming the x-axis cross the Y at 0) with the x-category values
your text cells, then add further Series as Scatter types

To do that add the first ...


Easier than I suggested last time -
- Add a row of zeros just below the 'hook' labels.
- Select all the data including the 'hook' and 'load' labels
- Create a Line style chart with markers
- Change the chart type Combo
- Leave the first dummy series as Line type
- Change the other 'load' series to Scatter type

This time no secondary axes were created, for me

Format the dummy Series Line to not be visible

Quick and easy, except it could have been simply a Line chart!

PT

Thanks Peter, for your perfact workaround. It worked as Combo Custom Combination with one series line keeping zero values.
Appriciate your valuable guidance.
Cheers!!