K
Karl Burrows
I am trying to figure out a way to add an additional Y-Axis line to a chart.
Current chart is a standard bar chart with about 10 rows of data (cost
breakdown). I want to add a cost per square foot, but when I try to add it
to the Y-Axis by creating a custom bar line chart, it wants to add other
lines of data to that axis. In addition, I can't get rid of the cost per
square foot in the data table. It is not a per project total like the bars
in the graph, but a cumulative cost per foot for all bars in the graph.
In addition, I want to show the totals of all the data per project without
adding it directly to the chart. I just want it in the bottom in the data
table.
Is there a way to create a bar line graph and set specific Y-Axis parameters
and how can I add additional rows without adding them to the chart?
Thanks!
Current chart is a standard bar chart with about 10 rows of data (cost
breakdown). I want to add a cost per square foot, but when I try to add it
to the Y-Axis by creating a custom bar line chart, it wants to add other
lines of data to that axis. In addition, I can't get rid of the cost per
square foot in the data table. It is not a per project total like the bars
in the graph, but a cumulative cost per foot for all bars in the graph.
In addition, I want to show the totals of all the data per project without
adding it directly to the chart. I just want it in the bottom in the data
table.
Is there a way to create a bar line graph and set specific Y-Axis parameters
and how can I add additional rows without adding them to the chart?
Thanks!