Data Table Chart_fill colour

[sachar]

Dear All,

With reference to the attached sample file, as you will see I made the Data Table Chart(Room Type Sale Chart) with the help of Chart Tools, but I could not get the impression of green colour fill in the chart as above the details.

May I know, how can I present the green color fill in the chart?

 

[Hui]

The problem is that your trying to plot data from 20% through to 200,000 on the same axis

Select one set of data at a time and do a chart for each column separately or at least only select columns where the numbers are similar

Also don't include the totals in the ranges

 

[sachar]

Dear,

Received with thanks, as I understood I selected only one set of Data (nights sold) but, still, the 869 number is not filled in the colour.

May I know, how can I do it.

 

[Hui]

See attached

Put values True or False in the yellow Column