Charts and sub-values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains 3 main columns. the first one is (company name)
and the other two are some numbers (values) related to that company. Within
company names, sometimes there are sub-companies related to the main company
with its sub values. I am trying to create a chart; the problem is that the
chart will show all the data including the sub values. I want excel to stop
charting sub-rows or values and just represent the main values in the main
rows. How can I do that?
 
Hi fofo:
I believe there are more options to do that. A quick,manual approach is to
hide the rows you don't want to see in your chart (Format/Rows/Hide). If you
have to redo this frequently, you could design a macro or copy the
information from the main companies to a new worksheet with VLOOKUP formulas,
and compiling the chart from this new sheet, but this is only sensible if
your chart format is more or less stable (I mean if the companies are
consistent all the time). Finally, you may check out the PivotTable /
PivotChart option.
Hope this is what you'r looking for.
GL, Henk
 
Back
Top